Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct question
I have the following Sumproduct formula and I'm getting a #Value error
=SUMPRODUCT(--(ISNUMBER(32:32)),--(YEAR(32:32)=U16)) I know that A32 is not a number, so the YEAR(32:32) part returns #VALUE for the first entry. How do I get around this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct question | Excel Discussion (Misc queries) | |||
A SUMPRODUCT question | Excel Discussion (Misc queries) | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) |