View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EricC EricC is offline
external usenet poster
 
Posts: 10
Default 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