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

=IF(AND(A1="X",A2="Y"),A3*A4,"criteria not met")


On 15 Sty, 16:37, 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

Like SUMIFS, but for multiplication??
 

Hi Eric

In the cell you want to display the output enter
=IF(AND(A1="x",B1="y"),C1*D1,FALSE) -replace false with whatever you want to
return.

"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

Like SUMIFS, but for multiplication??
 

I appreciate your responses. Thank you!

"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