Help With Invoice Sums

[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. D1220
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

 

[RagDyeR]

What's wrong with:

=SUM(D1220)

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. D1220)
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

 

[Guest]

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

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

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