Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
Post your formula.
-- "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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
We need to see your formulas. And if possible, the values in the cells.
Tyro "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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - 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? -- 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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: 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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
It is:
=IF(SUM(H7:H33)<4000,SUM(H7:H33),"$4,000") Thanks :-) "PCLIVE" wrote: Post your formula. -- "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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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: It is: =IF(SUM(H7:H33)<4000,SUM(H7:H33),"$4,000") Thanks :-) "PCLIVE" wrote: Post your formula. -- "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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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 -- "exflirt" wrote in message ... It is: =IF(SUM(H7:H33)<4000,SUM(H7:H33),"$4,000") Thanks :-) "PCLIVE" wrote: Post your formula. -- "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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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? "Marcelo" wrote: 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: It is: =IF(SUM(H7:H33)<4000,SUM(H7:H33),"$4,000") Thanks :-) "PCLIVE" wrote: Post your formula. -- "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? |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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? |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
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 -- "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? |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum won't calculate result of SUMIF function - help!
Ok. That's what I said earlier. Oh well. I'm glad it's working.
Regards. -- "exflirt" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate time, but if less then hrs, end result must be 1 hrs | New Users to Excel | |||
Query on how I would calculate a result in Excel? | Excel Worksheet Functions | |||
Sumif formula not giving result | Excel Discussion (Misc queries) | |||
sumif wrong result | Excel Worksheet Functions | |||
Is it possible to have a 3D sumif result? | Excel Discussion (Misc queries) |