This formula would sum current monthly total
=sum(if(MONTH(A1:A365)=MONTH(TODAY()),B1:B365,0))
What change would i have to make in the formula to sum "past 7 days" of current monthly total.
Also if a zero dollar ($0.00) amount entry is in the sum of the past 7 day total, how would you skip that entry and add only amounts greater than $0.01 for the past 7 days.
Thanks, Lazor99
=sum(if(MONTH(A1:A365)=MONTH(TODAY()),B1:B365,0))
What change would i have to make in the formula to sum "past 7 days" of current monthly total.
Also if a zero dollar ($0.00) amount entry is in the sum of the past 7 day total, how would you skip that entry and add only amounts greater than $0.01 for the past 7 days.
Thanks, Lazor99