Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with SUMPRODUCT Function
Hello -
I'm in need of some help. I need to count the number of occurences (rows) in a Worksheet, based on two criteria (column entries) in that row. I've been trying to use the 'SUMPRODUCT' function, but keep winding up with a value of 0 (although I know the answer should be 0, when I count portions manually). The formula I've been trying to use is below: =SUMPRODUCT((Data!K1:K3000="AL")*(Data!AB1:AB3000= "TRUE")) Where "Data!" is the tab the information is on (the report/detail I'm attempting to compile in on another tab), column K identifies the state (in this case AL), and column AB is a flag for whether or not a product has been included (the only values are True or False). I've tried everything I can think of, but still can't seem to get this to work. Any help would be most appreciated ! Thanks for your help, - Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct function / VB user defined function | Excel Discussion (Misc queries) | |||
SUMPRODUCT or another function??? | Excel Worksheet Functions | |||
SumProduct function | Excel Worksheet Functions | |||
Sumproduct function | Excel Discussion (Misc queries) | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions |