Hi all

I'm trying to use the SUMIF function simply to determine when values get pulled into a sheet. E.g. sum all values for may/15 or jun/15. For example in sheet 1 I have project income with dates in the format dd/mm/yy. In sheet 2 I want to pull in income based on mmm/yy to work out a profit and loss.

The function is simple bar one aspect. I use a date (dd/mm/yy) in column F of sheet 1 to show clearly when a payment is received. I then simplify this in column I to show just the month and year (so that I can amalgamate income per month without having to specify date ranges). What I did was simply type in "=F2" in I2 to pull in the date and then I set the format to mmm/yy. However, the underlying value is "=f2" as far as SUMIF is concerned so I get nowhere.

So the question is how do I successfully abbreviate the date in column I (based on the full date in column F) so that the date generalises to a value of "may/15" when the actual date input in column F is e.g. 10/05/15?

Many thanks

Dave