Thread: Calculating multiple cells depending on what month it is

I'm new here, so I am not sure if I can upload an example of my spreadsheet but I will try to explain as best I can should I not be able to upload it.

I have a cell I:6 I set the date in 1-Dec-10, then I:2 I have a cell that reads the current date from the computer=Today(), In the cell I:3 it spits out a calculation of the difference of months.

So that describes the date part. Then for this example I have three months set up with a series of dates in the A, C, E columns. In B, D, F I have a different number entered for that month and that date.

I want to have the spreadsheet calculate a series of cells depending on the what month it is. For instance I:3 has 7 months in it for July. I want the spreadsheet for the 7 month to add cells B:2 to B10. If it were August I:3 would say 8 months and then the sheet would add D:2 to D:10, and the same for September I;3 would say 9 months and the sheet would add F:2 to F:10.

The result would populate the cell A:15.

I love it Roger it's brilliant!!

Thanks so much for your assistance. I had a really convoluted IF statement at one point and it worked then I messed it up at some point. That's when I deleted what I had and found this web site and decided I need to find someone else to look at my issue.

You have made this much easier for me and it works! Thanks!

David