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

=SUMPRODUCT(--(range8),--(range<=11.99),--(sum_range))

--
Regards,
Dave


"DMM" wrote:

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

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

--

pdgaustintexas


--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: http://www.excelforum.com/member.php...o&userid=30600
View this thread: http://www.excelforum.com/showthread...hreadid=505443

You're right - it works
Thanks for the help

"pdgaustintexas" wrote:


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

--

pdgaustintexas


--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: http://www.excelforum.com/member.php...o&userid=30600
View this thread: http://www.excelforum.com/showthread...hreadid=505443