Sum various totals with a lookup sumif

Hi All,

I have a sheet of totals reporting on year, area and dept per area. Each generates thier own sale figures that are entered onto the main leger.

what i would like to do is to enter year,2013- to date, area North South west East, and deparment 1-4 by a drop down selection prefixing the cash entry on the row as it is entered. the ledger total represents the total amount of company sales / stock value, im good so far.

But i would also like have a three cells below the leger containing the 3 options so i could slecet a total of any of the combinations i.e 2013 , North , Dept 1 or what ever other combination of the 3 that may be required and it would return the total fro the comination selected.

thought this would be easy but its totaly beaten me.

Any help gratefully recieved.

Thanks,

Mil.