Sum a variable # of cells based on a date

[Don Beam]

I am trying to calculate the sum of values in column "C", based on the previous rows that are within a year of the date that is located in column "A" column.

I thought SUMIF would do it but I have not found the successful syntax to make this happen, or perhaps SUMIF does not have the functionality to do this.

I do not want to have to write a VBA script to do this if possible.

Any suggestions?

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[Don Beam]

first thank you for responding to my question.

I am sorry, I am new to this site and do not understand your comments of what I should do.

Are you suggesting to post the spreadsheet to use as a basis for discussion?

[AliGW]

Yes - a sample workbook. Do you see the yellow box at the top of the page? That's where the instructions are.

[Don Beam]

okay.. lets try the attached spreadsheet .. please note that column "D" is where the
formula would reside, and the results should be what I manually calculated.

I have uploaded a file called "SampleVariableSum.xlsx" ... I hope it got uploaded okay.

Again, thanks for the help

[AliGW]

Here you go - in E5 copied down:

=SUMIFS($C$5:$C$19,$B$5:$B$19,">="&B5,$B$5:$B$19,"<="&EDATE(B5,3))

[Don Beam]

if this works, I owe you big time ..... thanks

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Don Beam]

outstanding .. it works .. well done .. and where have you been all my life ....

I hope that I clicked the right "star" as this truly solved a big issue for me.

Thank you

[AliGW]

It was a pleasure.