Thread: Condensing Formula
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Condensing Formula
Hi Phil,

=SUMPRODUCT(--(sheet1!A3:A162=B11),sheet1!B3:B162)

You will need SUMPRODUCT if you ever introduce more than one sumif
criterion...

HTH,
Bernd

Reply With QuoteReply With Quote