I was trying to search for if this was possible, but I wasn't exactly sure what it would be called, so I thought that I'd post here.
I have a table with 10 rows (different programs) and 12 columns (different months). The table is for keeping track of an amount spent.
I would like to be able to create another column that finds the percentage for the amount spent/total originally available.
However, I don't want to create a whole table to calculate the values. I only want one column of percentage values.
I would like a formula to automatically calculate the percentage of each row, only for the most recent month.
For example, now I want it to calculate the November percentages, and next month when I input the December data, I want it to change to calculate the December percentages, without me having to redo the formulas.
How can this be done? I think it should be possible, but it is way beyond my excel knowledge.
Thaank youu!
Bookmarks