Help With Invoice Sums

  • Thread starter Thread starter AdRock
  • Start date Start date
A

AdRock

I am trying to create a blank invoice for a college assignment. I hav
worked out the sum for QTY multiplied by UNIT PRICE which gives
figure in the TOTAL PRICE and leaves blank if nothing entered but
want to work out a sub total at the bottom of the screen (e.g. D12:D20
so I can add VAT and have a GRAND TOTAL but I am not sure what the SU
or IF statement will be so any help would be very much appreciated

Thank
 
What's wrong with:

=SUM(D12:D20)

as your subtotal cell, then, in another cell, calculate your grand total
using the cell containing the above formula as a reference?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am trying to create a blank invoice for a college assignment. I have
worked out the sum for QTY multiplied by UNIT PRICE which gives a
figure in the TOTAL PRICE and leaves blank if nothing entered but I
want to work out a sub total at the bottom of the screen (e.g. D12:D20)
so I can add VAT and have a GRAND TOTAL but I am not sure what the SUM
or IF statement will be so any help would be very much appreciated

Thanks
 
As RagDyer says above for your sub-total....=Sum(d12:d20

Then your VAT.....=Sum((D12:D20)*"VAT")....of course without the quotes for the VAT

Then just add the two cells above for your grand total...or =Sum((D12:D20)*1."") Just add a 1 onto your VAT.
 
Back
Top