Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT problems...argh...
Hello, once again, I have to read 4 columns of info and count the records.
Here's the formula: =SUMPRODUCT(--(DropCode_Log!$B$10:$B$400=Totals!$A$17)*(DropCode _Log!$C$10:$C$400=Totals!$A19)*(DropCode_Log!$D$10 :$D$400=Totals!B$18)--(DropCode_Log!$G$10:$G$400="SIK")) Where Column B are dates, Column C are categories, Column D is a 2nd category, and Column G are codes... What am I doing wrong? Thanks in advance... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I, too, am having problems with SUMPRODUCT | Excel Worksheet Functions | |||
Sumproduct problems... | Excel Worksheet Functions | |||
SUMPRODUCT problems | Excel Worksheet Functions | |||
Problems with sumproduct | Excel Worksheet Functions | |||
formula I can't figure it out?! ARGH | Excel Worksheet Functions |