Sum won't calculate result of SUMIF function - help!

  • Thread starter Thread starter exflirt
  • Start date Start date
E

exflirt

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?
 
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?
 
hy,

it will be better if you send us a sample of your formula.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"exflirt" escreveu:
 
you try to force excel to return 4000 if the sum of your range is less than it.

correct?

=if(sum(H7:H33)<4000,sum(h7:h33),4000)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"exflirt" escreveu:
 
Your formula seems ok, except I would change from "$4,000" to 4000 and then
format your cell appropriately. This could just be a calculation issue.
Try pressing F9. If that fixes it, then you most likely have calculations
set to manual. Tools-Options-Calculation-Automatic.

HTH,
Paul

--
 
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.
 
Correct. I am working on a spreadsheet for a client showing the maximum they
would have to spend, so dollar amounts are a key part of it.

Removing the $$ sign does not make a difference, and I do have my
calculations set to Automatic under the Calculations tab.

Any other suggestions?
 
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)
 
So does the formula return anything at all? If it is just blank, then maybe
there is some conditional formatting on that cell causing the text to be the
same color as the background.

Just a thought.
Paul

--
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
Ok. That's what I said earlier. Oh well. I'm glad it's working.

Regards.

--

exflirt said:
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 said:
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 said:
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.

:

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

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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top