Forum Discussion

accounts's avatar
accounts
Copper Contributor
Jan 24, 2018

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: ...
Formulas & Functions
Need Help
accounts's avatar
accounts
Copper Contributor
Jan 24, 2018

Thank you so much for your reply.  I know that I am doing this the wrong way around, and there are so many ways to do it.  I haven't worked much with tables and graphs.  I have attached a basic beginning of some fake numbers that I would want represented.  At this stage, I just want a graph that shows membership growth by months, and then I would be looking at doing another one that shows percentage of advertising. 

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jan 25, 2018

    Hello again,

     

    First tip: avoid using merged cells. It makes selecting columns for formulas impossible. Instead of merging A1 to C1, unmerge, then select A1 to C1 and format them with the Alignment option "Center across selection". 

     

    You can summarize the new memberships per month in the Formulas sheet with this formula in cell B4, copied down:

     

    =COUNTIFS('Memberships 2018'!D:D,"Yes",'Memberships 2018'!A:A,Formulas!A4)

     

    in words: count all cells where Memberships!column D = Yes and Memberships!column A = the text in A4.

     

    Let me know if that helps.

Resources