sumif function
Posted by Brian on December 17, 2001 8:53 AM
Here is my range:
50
75
100
150
175
200
225
250
=SUMIF(G1:G8,"150<225")
How come this does not recognize this as between 150 and 225????
thanks,
Posted by Travis on December 17, 2001 9:16 AM
your formual reads sum if 150 is less than 225. Which is always true. I thnk you need an and statement in there, the sumif formula doesnt seem to like the and. Here is the long way around it.
=SUMIF(G1:G8,"<225")-SUMIF(G1:G8,"<=150")
Posted by Damon Ostrander on December 17, 2001 9:53 AM
Hi Brian,
This doesn't work because there are really two conditions here: >150 AND <225. I suggest you use the Condition Sum Wizard, which allows you to specify multiple conditions. It is an add-in, so you may need to install it (Tools->Add-ins) before you can use it.
Happy computing.
Damon
