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
Bookmarks