total of multiple rows + multiply
Thank you T. Valko it worked just fine
--
smile
"israel" wrote:
I have column A (10 rows with different amounts)
column B (10 rows with different amounts)
I need the total from column B once it was multiplied by A
I can do column C A*B and then B1:B10. What would be the formula without
creating column C
--
smile
|