Hey all! Need some help on finding a total. I have a column for each month and an amount assigned to each month. I need a worksheet formula to find a total from January to the current month. For example, if the current month is June, sum the numbers from January through June. This should be easy but it's kicking my @@@.
Oct 17 2006, 08:06 AM
Assuming your data is in columns A-L, in row 2, then try this:
Oct 17 2006, 08:13 AM
In a new Column enter the following formula:
a1 - this is where the month column is in your spreadsheet. Change this to the appropriate column.
d1 - this is where the Assigned Amount is in your spreadsheet. Change this to the appropriate column.
10- this represents the current month. So this is looking in cell A1 for Months from October and earlier. October is 10...obviously
After entering this formula in the first cell of the new column, Copy and Paste it to all the others. Then at the bottom of this column, Sum the column.
Oct 17 2006, 08:19 AM
Thanks to both of you. In this particular situation...I went with Stu's formula. I will keep them both tucked away for future use!
Oct 18 2006, 10:36 AM
Additionally, Index() gives you a non-volatile option, e.g.,
Although Today() is volatile... Depends what you're really feeding this thing...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.