offset formula to sum column from entered date downward

[Gerry]

In column A I have weekly dates entered
Column B, is the data to be summed

I need a formula that will sum column B from the date entered in C1 to
the end of the column

TIA

Gerry

 

[Pete_UK]

Try this:

=SUMIF(A1:A100,">="&C1,B1:B100)

Adjust the ranges to suit.

Hope this helps.

Pete

 

[Gerry]

Try this:

=SUMIF(A1:A100,">="&C1,B1:B100)

Adjust the ranges to suit.

Hope this helps.

Pete

Thanks Pete

Much easier than index match. Some functions you just forget about
when you don't use them that often.

Gerry

 

[Pete_UK]

Glad it worked for you, Gerry - thanks for feeding back.

Pete