index and match formula error

[LegoMason]

Hello,
I'm trying to create a payroll template to produce a journal entry for me. Rows 2 to 12 is the output from my payroll system. 15 to 22 is the template for my journal entry. I'm attempting to write a formula to sum the amounts for each department (column d) and expense category (column f-k). My attempt has an N/A error. Appreciate any help.

 

[AliGW]

You need SUMPRODUCT, not INDEX MATCH MATCH.

In C17 copied across and down:

=SUMPRODUCT($F$3:$K$12*($F$1:$K$1=$B17)*($D$3:$D$12=C$16))

 

[Janespola]

Thanks