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?