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).
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.
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.
- Sorry Peter, I was responding to my own post.
- Not sure I understand 2*MONTH(TODAY())
- The month function returns an integer between 1 and 12. Your example happened to add a number that was double the month number in each case. More general values could be returned by index from a reference array.