Ask Your Question

Revision history [back]

First off, this

=SUMIF(A4:A11;">TODAY()-30";B4:B11)

won't compute, because ">TODAY()-30" is just a text string. This will do:

=SUMPRODUCT(A4:A11>(TODAY()-30);B4:B11)