Hi, I've tried searching but all the info I can find uses a helper column. Is there a way to use SUMIF or SUMIFS to return the sum of data from the current week (Week day starting Monday) without adding a helper column.
I've tried =SUMIF(D:D,WEEKNUM(TODAY(),2),AA:AA)
Any ideas? Im sure it simple but everything just returns zero.
Cheers
I've tried =SUMIF(D:D,WEEKNUM(TODAY(),2),AA:AA)
Any ideas? Im sure it simple but everything just returns zero.
Cheers