Sumproduct

[Dominique Feteau]

i've heard much about this function, but not sure on how to use it for what
i need.

Some cells in Column A have the text "direct" or "indirect". columns C
through N are Jan through Dec.

I need to add up all the cells in column c (jan) that have "direct" or
"indirect" in Column A.

A C
Client Jan

direct 4950
one time 0
recurring 4950
direct 0
one time 0
recurring 0
direct 750
one time 0
recurring 750

So for this small one the total would be 5700.

btw i have 256 rows.

Dominique

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(((A2:A300="direct")+(A2:A300="indirect")),C2:C300)