View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cif Cif is offline
external usenet poster
 
Posts: 4
Default sumproduct with one variable criteria?

hi, i am interested doing something like this:
=SUMPRODUCT(--(B1:B12="criteria 1");--(M1:M12=B29);--(I1:I12))

where B29 represent a value that i introduce in cell b29

thanks in advance