View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Millie Millie is offline
external usenet poster
 
Posts: 17
Default Help needed with Formula

Can you use "AND", "IF" and "SUM" Functions together?

I want a formula that will do the following;
IF C:C = "Name" AND I:I = "5" then SUM K:K