| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem calculating
I am using the formula
=SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2: C10000.01)*(B2:B1000))/SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2:C 10000.01)*(C2:C1000)) It verifies that the criteria of year=2008 and that their is a value in both the B & C cells. it then totals the valid cells in B and divides it by the total of valid cells in C to give me a percentage. it works fine except i have to click in the formula and hit enter to get it to calculate. I have to do this in the manual mode only (F9 doesn't work either) becaus in atomatic it returns a value of zero, Please Help..... Thanks, Ron |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem calculating
You have an active thread elsewhere.
RonH wrote: I am using the formula =SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2: C10000.01)*(B2:B1000))/SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2:C 10000.01)*(C2:C1000)) It verifies that the criteria of year=2008 and that their is a value in both the B & C cells. it then totals the valid cells in B and divides it by the total of valid cells in C to give me a percentage. it works fine except i have to click in the formula and hit enter to get it to calculate. I have to do this in the manual mode only (F9 doesn't work either) becaus in atomatic it returns a value of zero, Please Help..... Thanks, Ron -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem calculating
What does that mean?
"Dave Peterson" wrote: You have an active thread elsewhere. RonH wrote: I am using the formula =SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2: C10000.01)*(B2:B1000))/SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2:C 10000.01)*(C2:C1000)) It verifies that the criteria of year=2008 and that their is a value in both the B & C cells. it then totals the valid cells in B and divides it by the total of valid cells in C to give me a percentage. it works fine except i have to click in the formula and hit enter to get it to calculate. I have to do this in the manual mode only (F9 doesn't work either) becaus in atomatic it returns a value of zero, Please Help..... Thanks, Ron -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem calculating
You were right. I had a sum going on at the end.
Thanks!!! "RonH" wrote: What does that mean? "Dave Peterson" wrote: You have an active thread elsewhere. RonH wrote: I am using the formula =SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2: C10000.01)*(B2:B1000))/SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2:C 10000.01)*(C2:C1000)) It verifies that the criteria of year=2008 and that their is a value in both the B & C cells. it then totals the valid cells in B and divides it by the total of valid cells in C to give me a percentage. it works fine except i have to click in the formula and hit enter to get it to calculate. I have to do this in the manual mode only (F9 doesn't work either) becaus in atomatic it returns a value of zero, Please Help..... Thanks, Ron -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem calculating | Excel Discussion (Misc queries) | |||
| Problem calculating Using a Percentage | Excel Worksheet Functions | |||
| Excel Calculating problem | Excel Discussion (Misc queries) | |||
| Problem calculating with a SUMIF | Excel Worksheet Functions | |||
| Problem Plotting/Calculating with #NA | Excel Discussion (Misc queries) | |||
Linear Mode
