SUMIFS Problem - A value used in the formula is of the wrong data type

Hi,

I have a spready with 3 sheets, expenses, outgoings, incomings

Each sheet contains a few named ranges

Expenses:

- ExpenseAmount
- ExpenseMonth
- ExpenseYear
- ExpenseType

Outgoings:

- OutgoingAmount
- OutgoingType

etc


In the expenses sheet I've created a formula


=SUMIFS(ExpenseAmount, ExpenseType, $K11, ExpenseMonth,MONTH(L$3), ExpenseYear, YEAR(L$3))


This sums the ExpenseAmount based on matching ExpenseType, ExpenseMonth, ExpenseYear and this is working fine.

However, when I do the same in

Outgoings
Incomings

with separate named ranges, I get an #VALUE error


Any idea why that is?

I've attached a sample spready.

thanks,

TT