Sum won't calculate result of SUMIF function - help!
That did it - thank you! I changed the "$4,000" to 4000 and let the cell
formatting turn it into $4,000.
THANK YOU!
"David Biddulph" wrote:
You're not adding a number 4000, you're adding a text string "$4,000" [as
you've enclosed it in quotes].
Either
=IF(SUM(H7:H33)<4000,SUM(H7:H33),4000)
or
=MIN(SUM(H7:H33),4000)
--
David Biddulph
"exflirt" wrote in message
...
There are many cells involved.
To try to simplify, I have three cells I am trying to add together using
the
SUM button. One contains the correct product of this function:
=IF(SUM(H7:H33)<4000,SUM(H7:H33),"$4,000"), namely, the dollar amount of
$4,000. The other two cells contain the amounts $20 and $80. When the
three
cells are added together using the SUM button, the dollar amount $100 is
returned. The cell with the $4,000 number is not registering for some
reason, and I need to figure out how to fix it without disturbing the
SUMIF
function.
Thanks again.
"David Biddulph" wrote:
What is your formula? What are the contents of the cells which feed into
the formula? What result are you seeing? What result did you expect?
--
David Biddulph
"exflirt" wrote in message
...
I am trying to include the product of a SUMIF function in a range of
cells
using the SUM button, but it is reading the cell as if nothing were
there.
Can anyone help?
|