Sheet summary formula to add number of attendees based on a program type?
I am trying to count number of attendees (one column) based on a different column (program type) we have running ("A" vs "B" vs "C"). I am getting unparseable. Any suggestions? I am trying to use the below formula:
=COUNTIF((Program:Program, "A")) (AND(=COUNTIF(Number of Attendees:Number of Attendees, >0)
I have also tried:
=COUNTIFS(Number of Attendees:Number of Attendees, >0, [Program]:[Program], "A"])
Best Answers
-
If I understand correctly, this should give you the results you want for the "A" condition. I am still unclear about your comparison between A, B, C... do you plan to show the results for each in different columns?
A couple of notes:
Instead of attempting to combine multiple COUNTIF statements with AND, you can use a COUNTIFS instead. In fact, you can actually use COUNTIFS for checking only one condition. I personally always use COUNTIFS instead of COUNTIF.
Anytime your column name includes a space (plus a few other conditions), you need to enclose it in square braces. I.E., [Number of Attendees] instead of Number of Attendees.
=COUNTIFS([POET PROGRAM]:[POET PROGRAM], "A", [Number of Attendees]:[Number of Attendees], @cell > 0)
If I am misinterpreting your request, please let me know.
-
Success! This is the final formula that worked:
=SUMIF([POET Program]:[POET Program], "A", [Number of Attendees]:[Number of Attendees])
Answers
-
If I understand correctly, this should give you the results you want for the "A" condition. I am still unclear about your comparison between A, B, C... do you plan to show the results for each in different columns?
A couple of notes:
Instead of attempting to combine multiple COUNTIF statements with AND, you can use a COUNTIFS instead. In fact, you can actually use COUNTIFS for checking only one condition. I personally always use COUNTIFS instead of COUNTIF.
Anytime your column name includes a space (plus a few other conditions), you need to enclose it in square braces. I.E., [Number of Attendees] instead of Number of Attendees.
=COUNTIFS([POET PROGRAM]:[POET PROGRAM], "A", [Number of Attendees]:[Number of Attendees], @cell > 0)
If I am misinterpreting your request, please let me know.
-
Thank you!
For example, I would love to have the formula count how many participants are in each program "A". There are 25+ rows that include program 'A' versus another program 'B' (which I will also want to add the amount of participants for program 'B").
Might I need a =SUM formula instead?
-
Success! This is the final formula that worked:
=SUMIF([POET Program]:[POET Program], "A", [Number of Attendees]:[Number of Attendees])
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!