Confused, SUMPRODUCT or SUMIFS to compare 2 dates in a row

Hi

I am unsure of the crrect way to go about this task.

I have these columns in my Excel table

COL A: An £amount, (which represents is an upcoming bill payment)
COL B: the due date for the bill
COL C: A date set by the user to be reminded of the forthcoming payment

I am trying to write a formula that will SUM all forthcoming payments that are after the reminder dates set by the user in COL B. This formula will naturally be outside the table itself.

As the title declares I'm confused about whether this needs to be an array formula say with SUMPRODUCT or if it can be achieved with a SUMIFS in EXCEL 2007

Many thanks all

Perhaps something like..

=SUMIF(B:B,C2,A:A)


EDIT: Apologize. You said after the reminder dates...

=SUMIF(B:B;">"&C2;A:A)

If you just want to sum where the reminder date is <= today then you can use this formula

=SUMIF(C:C,"<="&TODAY(),A:A)

.......but that would also include amounts where the due date has passed so if you want to exclude those rows try this version

=SUMIFS(A:A,C:C,"<="&TODAY(),B:B,">="&TODAY())