I have a speadsheet with columns as under:

Account Code Department Amount
------------ ---------- ------
7000 12 £100
7050 5 £250

There are a couple of hundred rows with different account numbers and a
variety of Department numbers.

Is there a way I can use SUMIF to summarize the amounts by Code AND
Department? In other words I want to sum ALL the amounts with Code 7000
and Dept 12 etc.

Thanks!