| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why won't Sumproduct funciton evaluate this data
I have written a formula that evaluates whether a set of numbers is
"Red", "Yellow" or "Green" based upon whether the numbers meet certain criteria. I would then like to count the number of "Red" instances. I have named the range of data(Red,Yellow, Green). I can't figure out why the following function returns a #DIV/0! SUMPRODUCT(--(BadDebt=$E$8)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why won't Sumproduct funciton evaluate this data
I'd look in the BadDebt range for errors--don't forget to look in hidden
rows/columns. wrote: I have written a formula that evaluates whether a set of numbers is "Red", "Yellow" or "Green" based upon whether the numbers meet certain criteria. I would then like to count the number of "Red" instances. I have named the range of data(Red,Yellow, Green). I can't figure out why the following function returns a #DIV/0! SUMPRODUCT(--(BadDebt=$E$8)) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Utilizing a portion of data in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Linear Mode
