I encountered the following problem yesterday on a cash report spreadsheet.
I’m trying to write a formula to sum all budget items for future years, I think the formula I need is;
=SUMIF(Year2,>Year1,E5:BF5)
(Where Year2 is a range of budget years, E5:BF5 the respective range of budget amounts to be summed and Year1 the year from which I want to calculate all budgets after).
The above formula returns the answer 0, but if I try
=SUMIF(Year2,Year1,E5:BF5)
It sums all budget items for Year1 correctly, and;
=SUMIF(Year2,Year1+1,E5:BF5)
Sums all budget items for the year after Year1, so I’m mystified as to what is wrong with the criteria “>Year1”.
In line with excel help I’ve tried entering the criteria in quote marks (the only thing I could see that was different in their example) and I’ve also tried separating the criteria with brackets.
Any help, advice or suggestions gladly received.
GB
I’m trying to write a formula to sum all budget items for future years, I think the formula I need is;
=SUMIF(Year2,>Year1,E5:BF5)
(Where Year2 is a range of budget years, E5:BF5 the respective range of budget amounts to be summed and Year1 the year from which I want to calculate all budgets after).
The above formula returns the answer 0, but if I try
=SUMIF(Year2,Year1,E5:BF5)
It sums all budget items for Year1 correctly, and;
=SUMIF(Year2,Year1+1,E5:BF5)
Sums all budget items for the year after Year1, so I’m mystified as to what is wrong with the criteria “>Year1”.
In line with excel help I’ve tried entering the criteria in quote marks (the only thing I could see that was different in their example) and I’ve also tried separating the criteria with brackets.
Any help, advice or suggestions gladly received.
GB