Sumproduct

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

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
 
Back
Top