Hi there, It doesn't work - Excel returns the #VALUE? error. Any suggestions
K Kreller Oct 19, 2004 #1 Hi there, It doesn't work - Excel returns the #VALUE? error. Any suggestions
D Dave Peterson Oct 20, 2004 #2 Do you have any #value! (or other errors in your ranges (N:0)) ps. I like this format for the date: =SUMPRODUCT(--(N2:N1000="Meeting"),--(O2:O1000=DATE(2004,10,18)))
Do you have any #value! (or other errors in your ranges (N:0)) ps. I like this format for the date: =SUMPRODUCT(--(N2:N1000="Meeting"),--(O2:O1000=DATE(2004,10,18)))
