Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting multiple variables returns #VALUE
I am attempting to count the number of engineering drawings with an E in the name in column O. Between to dates in column F. This returns 66 if I just want to find the number of "E" drawings in column O: SUMPRODUCT(--(ISNUMBER(SEARCH("E",ECNT!O2:O690))) But when I tried to add a date range for column F to the formula it returns #VALUE: SUMPRODUCT(--(ISNUMBER(SEARCH("E",ECNT!O2:O690))),--(ECNT!F2:F690=DATE(2005,4,1)),--(ECNT!F2:F690<=DATE(2005,4,7))) What gives? Any help would be greatly appreciated. -- was ------------------------------------------------------------------------ was's Profile: http://www.excelforum.com/member.php...o&userid=20211 View this thread: http://www.excelforum.com/showthread...hreadid=395173 |
#2
|
|||
|
|||
I'd look for errors in F2:f690.
Select that range edit|goto|special check constants and then uncheck all but errors If that didn't find something, then do the same for formulas. (don't forget to look in hidden rows.) was wrote: I am attempting to count the number of engineering drawings with an E in the name in column O. Between to dates in column F. This returns 66 if I just want to find the number of "E" drawings in column O: SUMPRODUCT(--(ISNUMBER(SEARCH("E",ECNT!O2:O690))) But when I tried to add a date range for column F to the formula it returns #VALUE: SUMPRODUCT(--(ISNUMBER(SEARCH("E",ECNT!O2:O690))),--(ECNT!F2:F690=DATE(2005,4,1)),--(ECNT!F2:F690<=DATE(2005,4,7))) What gives? Any help would be greatly appreciated. -- was ------------------------------------------------------------------------ was's Profile: http://www.excelforum.com/member.php...o&userid=20211 View this thread: http://www.excelforum.com/showthread...hreadid=395173 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
How can I solve for multiple unknown variables in Excel? | Excel Discussion (Misc queries) | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |