Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

INCORRECT APPROACH TO EXCEL 2007 THE MISSING MANUAL:REVENUES ' CALCULATION IS INCORRECT- see pg. 616

Re: Excel 2007 The Missing Manual, pg. 616. In order to calculate Sum of Revenues you first add "Unit Price" column, then add "Quantity", and then you multiply the sum of Unit Price by the sum of Quantity. I am an accountant, I do not understand the logic to this approach. I think that the calculation that should be performed is multiply EACH Unit Price by its CORRESPONDING Quantity per each PRODUCT, then sum the results of all the products in order to arrive at total revenues. Please try my approach, you will see that the amounts are SIGNIFICANTLY different! Can you please send me your answer to carpentersusana@hotmail.com? Thank you very much!!!
1 person has
this problem
+1
Reply