Hi
Presumably you have a column with Vat code, lets say column C, and a column
with the Net amount, say column D.
Assuming your values are in rows 2:20 then
=SUMIF($C$2:C$C20,"S",$D$2
$D20)*17.5%
If you needed it for Lower rate, then
=SUMIF($C$2:C$C20,"L",$D$2
$D20)*5%
If you had both S and L and wanted a single Total VAT figure than add the 2
formulae together in the same cell
=SUMIF($C$2:C$C20,"S",$D$2
$D20)*17.5%+=SUMIF($C$2:C$C20,"L",$D$2
$D20)*5%
All other codes would be 0% VAT and would not need to be added to the total.
Change ranges to suit.
Regards
Roger Govier