SUMIF/COUNTIF: using more than one criteria

[MickyD]

I'm trying to use SUMIF and COUNTIF based on more than one criteria.

I work in an accounting firm and I am trying to sum the total of Fee
Invoiced where Write-Offs are within certain ranges. Such as less tha
0, between 0 and 2.5%, between 2.5% and 5% etc.

For example, I have my values for Fees Invoiced in cells A1:A10, an
Write-Off percentages in cells B1:B10.

If I wanted to find all Write-Offs greater than 2.5% I would use th
following formula:

=SUMIF(A1:A10,">2.5%",B1:B10)

However, how do I include only Write-Offs greater than 2.5% but les
than 5.0%? I've tried using AND within my criteria, but I cannot get i
to work.

More Info:
I actually have my criteria in the header row, so my criteri
references are to cells, rather than actual values within the formula
In this way, I can easily change my criteria and have my formula resul
recalculate.

I know to use the "&" (such as =SUMIF(A1:A10,">"D1,B1:B10).

If this makes a difference to your responses, please bear that i
mind.


Thanks for any help provided

 

[Bob Umlas]

These functions are for 1-test only. Use SUMPRODUCT:
=SUMPRODUCT((A1:A10>.025)*(A1:A10<.05)*B1:B10))
Bob Umlas
Excel MVP

 

[MickyD]

Thanks for the help - works beautifully