Sumproduct??

D

drizzy

I was going to use sumproduct but i cant get it to work so i am thinking it
is the onrg formula

I have two columns (well more really but only 2 in each calc).

Column A will be blank or have "C" in it
Column B will have a monitary value
There are a lot of rows

I want to say

If Col A has a C then add the value in column B

So there will be multiple rows with C in and i want a total value of column
B that have the corresponding C in col A
 
B

Bill Kuunders

sumif(A:A,"C",B:B)

or
=SUMPRODUCT((A1:A12="C")*(B1:B12))

can't do full columns in sumproduct
 
T

Teethless mama

"can't do full columns in sumproduct"

The latest version XL2007, yes you can do full columns but not the early
versions
 
Top