View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
agilek9 agilek9 is offline
external usenet poster
 
Posts: 3
Default Summing/Counting Data in One Column Based on Criteria Another Col

This level of Excel complexity is a little above my skills, and am hoping
that someone can help.

I have numbered data in one range of cells (e.g., b1:b158) and alpha
criteria in another (e.g., "apples", "oranges", "pears" in c1:c158). I am
trying to sum the data in cells b1:b158 based on the criteria in cells
c1:c158, and put the result in a third cell. So for example, the sum of the
numbers in column b would be put in cell d1 if the criteria in c1:c158 was
equal to "apples"; the sum of the numbers in b would be put in d2 if the
criteria in c1:c158 was "oranges", etc.

Anyone have any suggestions? Thanks in advance for your help.
--
agilek9