sum column A based on column B
 

I have 2 columns. Col A1:A15 has my data andd col B1:B15
has a letter A, B or C in the cells. I want my summary
cell to sum only col A data when col B = A for the range.
Thanks for your help. Dan
col col
A B

13 C
23 A
21 B
67 A
45 A
etc

summary cell =135

sum column A based on column B
 

Hi Dan

you can use SUMIF
=SUMIF(B1:B15,"A",A1:A15)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Dan" wrote in message
...
I have 2 columns. Col A1:A15 has my data andd col B1:B15
has a letter A, B or C in the cells. I want my summary
cell to sum only col A data when col B = A for the range.
Thanks for your help. Dan
col col
A B

13 C
23 A
21 B
67 A
45 A
etc

summary cell =135