Forum Discussion
IF cell is YES, then add 1 to January based on Month Added
I am trying to create a marketing spreadsheet that shows new memberships added every month. I have a basic form that other can fill out by adding Month added, Yes etc. I want the formula to say:
...
Hello,
the approach is not how Excel works. You can't change a number in another cell with a formula.
But you can easily count how many dates fall into January, February, etc. You can use a Pivot table or a Pivot chart, which do not require any formulas, just dragging and dropping things.
Or you can use formulas like SumProduct() to total membership numbers by month.
In order to give you more detailed advice, it would be good to see a workbook with your data structure.