View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 272
Default Question for Mr. T Valko

Oops, i think there was a typo: Change (B$3:B$13="A")/(C$3:C$13="C") to
MMULT((B$3:B$13="A")*(C$3:C$13="C"),1) for non-array entry.