Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct question
What am I doing wrong he
=SUMPRODUCT(AL3:AL84="3/1/2006")*(AP3:AP84=6) I want to count the number of times AL3:AL84 = 3/1/2006 AND AP3:AP84 = 6. I keep getting ZERO when this is a non zero number. I have entered it with CTRL SHIFT ENTER (I think that's it) and it has {} around it. Thanks, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
sumproduct question | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions |