View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob
 
Posts: n/a
Default sum with three criteria

I am trying to sum a column if three criteria are met in one column. In
other words if Colum L has an EB, F, and EF then sum these in Column BB.
Here is what I have but this doesn't seem to work. I'm wondering if it is
because the criteria is all in the same column. I have used Sumproduct on
three different columns but not where the criteria is all in the same column.
Can someone help?

=SUMPRODUCT($L51:$L60="FB")*($L51:$L60="EB")*($L51 :$L60="F")*(BB51:BB60)