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

=SUMIF(A:A,"C",B:B)

"drizzy" wrote:

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

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

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

can't do full columns in sumproduct


--
Greetings from New Zealand


"drizzy" wrote in message
...
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

"can't do full columns in sumproduct"

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


"Bill Kuunders" wrote:

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

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

can't do full columns in sumproduct


--
Greetings from New Zealand


"drizzy" wrote in message
...
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