How do I make this formula show yesterday, the day before that, and so on up to 90 days back???
=SUMIF(Bankroll!Q14:Q6000,TODAY(),Bankroll!Y14:Y6000)
How do I make this formula show yesterday, the day before that, and so on up to 90 days back???
=SUMIF(Bankroll!Q14:Q6000,TODAY(),Bankroll!Y14:Y6000)
Yesterday is just TODAY()-1
If you want 91 separate formulas then probably best to put this formula in A2
=TODAY()
Then in A3 copied down to A92
=A2-1
Then you can use your formula in B2 copied down, but revised to:
=SUMIF(Bankroll!Q$14:Q$6000,A2,Bankroll!Y$14:Y$6000)
Exactly what I was trying to do. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks