sumifs with greater than and equals criteria

[iamfarhanmahmood]

Hello,

Please Guide me On Following.

i want to sumifs on second criteria >0<30

ist criteria is text based match which is working.

Regards Farhan

 

[etaf]

try
sumifs(1st range, 1st criteria, range, ">0", range, "<30")

 

[Ron Coderre]

Try something like this:

=SUMIFS(sum_range,criteria_range,">0",criteria_range,"<30")

Is that something you can work with?