Hi,
Hoping someone can tell why this isn't working or offer me an alternative non VBA solution.
The users of this sheet are using date names (Jan, Feb, etc) rather than actual dates (01.01.22 etc)
I'm then trying to use sumifs with a less than function, but from my testing it looks like I needed to convert them all into numbers rather than names.
I'm currently using the below formula but its not working and I'm not sure why. F9 on each individual part works but it doesn't like the formula as a whole.
=SUMIFS(BYM!K:K,BYM!B:B,"",MONTH(DATEVALUE(BYM!AA:AA&1)),">="&MONTH(DATEVALUE($D$22&1)))
Column K = Totals I am summing up
Column B = A status that just needs to be blank
Column AA = Date by name (Jan, feb, etc)
D22 = the date it needs to be less than
Does sumif not like Month(datevalue) on an array or something? or am I just blind to something obvious?
Thanks
Marc
Hoping someone can tell why this isn't working or offer me an alternative non VBA solution.
The users of this sheet are using date names (Jan, Feb, etc) rather than actual dates (01.01.22 etc)
I'm then trying to use sumifs with a less than function, but from my testing it looks like I needed to convert them all into numbers rather than names.
I'm currently using the below formula but its not working and I'm not sure why. F9 on each individual part works but it doesn't like the formula as a whole.
=SUMIFS(BYM!K:K,BYM!B:B,"",MONTH(DATEVALUE(BYM!AA:AA&1)),">="&MONTH(DATEVALUE($D$22&1)))
Column K = Totals I am summing up
Column B = A status that just needs to be blank
Column AA = Date by name (Jan, feb, etc)
D22 = the date it needs to be less than
Does sumif not like Month(datevalue) on an array or something? or am I just blind to something obvious?
Thanks
Marc