Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like SUMIFS, but for multiplication?? | Excel Discussion (Misc queries) | |||
Multiplication | Excel Worksheet Functions | |||
multiplication | Excel Worksheet Functions | |||
Number OK in multiplication, NOT in Sum ? | Excel Discussion (Misc queries) | |||
Multiplication Table | Setting up and Configuration of Excel |