Thread: Woman age 40
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Woman age 40
=SUMPRODUCT(--(A2:A13="woman"),--(B2:B13=40))

Regards,
Stefi

Tony_student ezt *rta:

A közösség üzenetei nem érhetők el
Reply With QuoteReply With Quote