View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jettp
 
Posts: n/a
Default How to add one column if 2 other columns have a specific value

I'm trying to get the sum of column F(Revenue dollars) if column B = Jan,
Feb, or Mar AND column D = YP.

I have tried SUMIF and SUMPRODUCT, but can't figure it out...