"COUNTIF" function

[Guest]

Trying to use "AND" function in criteria portion of "COUNTIF" function. More
specifically want numbers to sum if the number in the "range" falls between
two numbers e.g. AND(>8,<=11.99). In this example all numbers in the "range"
that fall between 8.01 and 11.99, their corresponding number in the
"sum_range" should be summed. I can't seem to make this work. Any
suggestions?

Thanks

 

[Guest]

=SUMPRODUCT(--(range>8),--(range<=11.99),--(sum_range))

 

[pdgaustintexas]

This formula works for me:

=SUMIF(G6:G48,">=8.01",E6:E48)-SUMIF(G6:G48,">11.99",E6:E48)

Column G contains the amounts you want to sum
Column E is the criteria

 

[Guest]

You're right - it works
Thanks for the help