Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct(?)
Hello. I want to count the dates in column B where the corresponding value
in column A is 'Sched'. Expecting the answer to be: 2 for the example below. I've tried to use and array (which i rarely use), i've also looked into SUMPRODUCT (which i've never used). I haven't had any luck with either. Can anyone help please? A B 1 Sched 2/15/2007 2 2/19/2007 3 Sched 3/1/2007 4 Sched 5 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT has never let me down BUT... | Excel Worksheet Functions | |||
Please help w/Sumproduct! | Excel Worksheet Functions | |||
Using SumProduct in VB | Excel Discussion (Misc queries) | |||
Sumproduct..help please | Excel Worksheet Functions | |||
now() sumproduct. | Excel Worksheet Functions |