Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob
 
Posts: n/a
Default sumproduct

I am trying to sum with 3 criteria but not as complicated as in different
row. I tried this formula but it doesn't seem to work. I want to sum if the
column equals, f,eb, fb.l The would be or so I asking sum all cells that
have an f+eb+fb.

=SUMPRODUCTR((L7:L2589=f)*(L7:L2589=FB)*(L7:L2589= EB))
Please help