Hi All
I have a sum ifs formula which I'm trying to get to create the sum of column O but only the last 7 days of data from today.
=SUMIFS(Data!G:G,A2,Data!O:O,Data!P:P,""=TODAY()-7)
the Data P column has Dates going back 1 year
Can't seem to get it to work. Any help would be much appreciated.
I have a sum ifs formula which I'm trying to get to create the sum of column O but only the last 7 days of data from today.
=SUMIFS(Data!G:G,A2,Data!O:O,Data!P:P,""=TODAY()-7)
the Data P column has Dates going back 1 year
Can't seem to get it to work. Any help would be much appreciated.