View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ansoriano1 ansoriano1 is offline
external usenet poster
 
Posts: 9
Default How do I apply conditional formulas across multiple columns?

Say my data set looks like this:
A B C

Molly April Candy
Sally April Candy
Sally May Soda
Molly May Soda
Amy June Candy
Amy June Soda

How do I create a function that finds out How many Candy are associated with
Molly in April?

How many candy are associated with April?

Thanks!