I want to multiply the price times quantity and summ it up. Obviously multiplying columns is not valid. I know i could make a second column where the "price X quantity" is represented and then summ it up. But I dont want some additional space be used, and I beleive numbers should be smart enough to handle this request. Is it possible?

enter image description here


I found it out. There is a SUMPRODUCT() function, that multiply ranges. This makes the result


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .