| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Sumproduct when some of the values are null
I am having a problem using Sumproduct when some of the cells have
null values. I will try to describe the problem. Please let me know if you need additional information. Do any of you have any ideas of how I can fix that sumproduct to get it to work? A B C Row Trend Claims 5 Emergency $0 6 Emergency $0 7 Emergency $0 8 Emergency 81.68% $24,444 9 Emergency 35.00% $164,758 10 Emergency 35.00% $215,237 11 Emergency 22.73% $105,059 12 Emergency 8.46% $53,760 20 Emergency $563,258 My goal is to calculate an aggregate trend for the Emergency Category excluding those rows that are null trend in cell b20. I tried the following formula: SUMPRODUCT((A20=A5:A12)*(A5:A12)*b5:b12)/c20 The result s "#Value" Do you know how to get this to work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to replace null values with zero? | Setting up and Configuration of Excel | |||
| If values of Cell are Null........... | New Users to Excel | |||
| Trouble with null values | Excel Worksheet Functions | |||
| sum if - null values | Excel Discussion (Misc queries) | |||
| return a " " for null values | Excel Worksheet Functions | |||
Threaded Mode
