Hi everybody,
I need to compare two rows of text and multiply the values if the text matches. It would be something like SUMIF, but with multiply instead of sum. For example:
mouse- 1 monitor- 30 mouse- 10*1
keyboard- 2 mouse- 10 keyboard- 15*2
monitor- 1 keyboard- 15 monitor- 30*1
I want it to work like SUMIF, compare the first two ranges and multiply the corresponding values.
Thank you very much for your help!
I need to compare two rows of text and multiply the values if the text matches. It would be something like SUMIF, but with multiply instead of sum. For example:
mouse- 1 monitor- 30 mouse- 10*1
keyboard- 2 mouse- 10 keyboard- 15*2
monitor- 1 keyboard- 15 monitor- 30*1
I want it to work like SUMIF, compare the first two ranges and multiply the corresponding values.
Thank you very much for your help!