Like SUMIFS, but for multiplication???
 

I want to multiply two cells in a row that meet multiple criteria from other
cells in that same row (like SUMIFS, but for a product). How can this be
done??

ex: A1 is X, A2 is Y, A3 is 3, A4 is 4

Multiply A3*A4 only if A1=X and A2=Y (both criteria met)

Thanks,

Eric

Like SUMIFS, but for multiplication???
 

EricC wrote...
I want to multiply two cells in a row that meet multiple criteria from other
cells in that same row (like SUMIFS, but for a product). How can this be
done??

ex: A1 is X, A2 is Y, A3 is 3, A4 is 4

Multiply A3*A4 only if A1=X and A2=Y (both criteria met)

You may have overly simplified your example because this could be done
simply as

=IF(AND(A1=X,A2=Y),A3*A4,0)

Like SUMIFS, but for multiplication???
 

I appreciate your response. Thank you!

"Harlan Grove" wrote:

EricC wrote...
I want to multiply two cells in a row that meet multiple criteria from other
cells in that same row (like SUMIFS, but for a product). How can this be
done??

ex: A1 is X, A2 is Y, A3 is 3, A4 is 4

Multiply A3*A4 only if A1=X and A2=Y (both criteria met)

You may have overly simplified your example because this could be done
simply as

=IF(AND(A1=X,A2=Y),A3*A4,0)

Like SUMIFS, but for multiplication???
 

Your example is confusing, because you talk about cells in a row, but
then list cells in a column.

However, *perhaps* you're looking for something like:

=SUMPRODUCT(--(A1:A100="X"),--(B1:B100="Y"), (C1:C100)*(D1:D100))





In article ,
EricC wrote:

I want to multiply two cells in a row that meet multiple criteria from other
cells in that same row (like SUMIFS, but for a product). How can this be
done??

ex: A1 is X, A2 is Y, A3 is 3, A4 is 4

Multiply A3*A4 only if A1=X and A2=Y (both criteria met)

Thanks,

Eric