Forum Discussion

rcortesim's avatar
rcortesim
Copper Contributor
Jan 07, 2022
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...
excel
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Jan 07, 2022

    rcortesim 

    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).

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 07, 2022

rcortesim 

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.

  • rcortesim's avatar
    rcortesim
    Copper Contributor
    Jan 07, 2022
    Using something like Month(Now())? Then, take that value + value of A1? It can't be that easy, can it?
    • rcortesim's avatar
      rcortesim
      Copper Contributor
      Jan 07, 2022
      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.
      • rcortesim's avatar
        rcortesim
        Copper Contributor
        Jan 07, 2022
        Sorry Peter, I was responding to my own post.

Resources