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.
|