Can you please advise what is wrong with this formula? It is currently returning an error?
=SUMIFS(Data!$K$2:$K$21,Month(Data!I2:I21),"="&MONTH(J7))
K2:K21 are the amounts
I2:I21 are the dates
J7 is the date from which I want to use the month to return the sum of matching amounts.
Pls advise.
Bookmarks