SUM value of previous day

[Tomosek]

Hi!

I'm having trouble coming up with a formula. Well, it is to consist in the sum of the values ​​from the previous day, which were paid on specific days. For me these days are 30.09.2020, 01.10.2020 and 02.10.2020.

The main formula is to count the value of payments every day ONLY from the previous day (TODAY () - 1). I combined a lot with SUM IF, but none of this :-(

I would like to ask for help.
Thank you in advance.

png.png

[Pepe Le Mokko]

Like this ? =SUMPRODUCT(--(A2:A31=TODAY()-1)*B2:B31)

( always add some manually caluclated examples just to be sure)

[Tomosek]

Oh thanks. I's working perfectly :D

[Pepe Le Mokko]

You're welcome. to be on the safe side add absolute references or use dynamic ranges or an Excel Table as source