Forum Discussion
Solved
Sum two cells by a value per each month in a single cell
I've not yet found an article that sums in a single cell for each month. The only ones I've read put the dates on separate rows, but that isn't what I'm trying to do. Hopefully, there is a formula th...
If cell contains user input it is illegal to also have a formula because that would change the input. If the month were derived from a formula, then something of the form
= input + 2*MONTH(TODAY())is possible ('input' here referring to the content of cell A1).
That doesn't work, you need another cell(s) of formulae which defines values for months, with that sum it with A1 placing result in A2.
Using something like Month(Now())? Then, take that value + value of A1? It can't be that easy, can it?
- No, I would have to give the Month(Now()) a value for each month that is returned, e.g.,
if Jan, then value is 2.
if Feb, then value is 4
etc.
Finally, I'd have to add that value to value of A1.