Excel Formula Problem

Taff™ 16:09 03 Feb 07
Locked

I am attempting to sort out an invoice spreadsheet to show VAT. Typically I have (For 8 items) a column showing a quantity, A description and a Unit cost. The next column has the formula =IF(SUM(P2*R2)>0,SUM(P2*R2),"")to calculate the extended cost of the item. (Quantity x Unit Cost)

After 8 sets of columns I have put in a formula that reads =SUM(S2+W2+AA2+AE2+AI2+AM2+AQ2+AU2)which adds up all the extended values - except it`s returning a #Value! Obviously I`ve made a mistake! Anyonepoint me in the right direction because I need to evaluate the VAT in a similar way.

VoG II 16:14 03 Feb 07

1st formula should be

=IF(P2*R2>0,P2*R2,"")

2nd formula should be

=SUM(S2, W2, AA2, AE2, AI2, AM2, AQ2 ,AU2)

or

=S2+W2+AA2+AE2+AI2+AM2+AQ2+AU2

Taff™ 16:27 03 Feb 07

Thanks VOG™ that sorted out the VAT column as well I think! I`ll leave this open for a while and test the rest of the spreadsheet with some dummy figures.

This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…