| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT troubleshooting
Hi all, I've finally got the formula to work! Hurrah! Thanks Dav. In case anyone wanted to know the end of the story: it turns out that my data was clean enough for a SUMPRODUCT = (count of rows that apply), but not clean enough for a SUMPRODUCT = sum(applicable numbers in column N). There were cells in column N with comments such as "n/a". I've since cleaned those up and the forumla works fine. It pains me that I will still have to amend the reporting data that gets to me every month in order to process it, as the formula can't cope with cells that clearly aren't numbers; but at least my spreadsheet works! Joy! Thank you very much all! Cath -- CathB ------------------------------------------------------------------------ CathB's Profile: http://www.excelforum.com/member.php...o&userid=34291 View this thread: http://www.excelforum.com/showthread...hreadid=540573 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Hybrid Mode
