View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DianeG DianeG is offline
external usenet poster
 
Posts: 59
Default Sum function with asterisks

I have been given this function and understand what its doing but don't
understand what the asterisks are for, is it for multiplying or are they
wildcards?

=SUM((A2:A10="Phone")*(B2:B10="Jones")*C2:C10)

I've never seen them used like this before. Help please!

Diane