View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimar jimar is offline
external usenet poster
 
Posts: 25
Default sum if column is equal to 2 options

Column A contains 3 types of data ie apples, oranges or lemons. Column B
contains the number of each item purchased and col C contains the date of
purchase. I need a formula which will count the total number of apples and
oranges purchased in May. (Answer should be 20) Grateful for any help.

Col A Col B Col C
apples 5 4/5/08
apples 6 6/5/08
lemons 4 7/5/08
apples 1 1/6/08
oranges 9 3/5/08