There are values (Unit Sold) in A2:A10 range.
There are values (Unit Price) in B2:B10 range.
I want to calculate Income. (Unit Sold * Unit Price)
How should be the formula?
A2:A10 and B2:B10 ranges are arrays. These are used in formula as array constants here.
=({A2:A10}*{B2:B10}) It won't work.
Do I have to write values (From A2 to A10) in array constant one by one? like {1;4;5;7}
Bookmarks