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