View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default 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