View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben
 
Posts: n/a
Default sun total of one column using criteria in another column

how do you add up a series of numbers in one column using a critera of
another column?

Column A Column B
Apples 1,112
Pears 1,548
Apples 2,544

What is the total number of apples...??? What is the right formula

if(a1:a3=Apples then add B 1:b3)