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