View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default is there anyway to use sumif using 2 criteria

Use SUMPRODUCT

=SUMPRODUCT--(C2:C10=condition1),--(E2:E10=condition2),A2:A10)

HTH

"Steve 51" wrote:

I am trying to sum the values in a column based on data in two other columns
of the same row meeting specific criteria.

I have data in A2:A10, C2:C10 and E2:E10 and I only want to sum the values
in A2:A10 if spedified, different criteria is met in BOTH C2:C10 and E2:E10.