SUMIF today is more than 31 days past date in cell

[scrapperdude]

I sell insurance and am trying to create a formula for a tracker I use for my sales. I want the formula to add up the sum of premiums for policies that have had 2 payments made, so 1 month after the effective date. What would a formula look like if I wanted to sum the annual premium in column D if todays date is equal to or greater than 31 days after the date in column G? Would SUMIF be the best way to do this?

Thanks!

[Gregb11]

Sumif would do, but I never use SUMIF anymore because you can use SUMIFS instead and it's more flexible. In this case, could use something like:

=SUMIFS(D:D,G:G,"<="&today()-31)

If this doesn't work for you, please read the yellow banner at the top of the page and attach a sample file.