"COUNTIF" function

[DMM]

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

[David Billigmeier]

=SUMPRODUCT(--(range>8),--(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
>

[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

--

pdgaustintexas

[DMM]

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
>
>