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"])

Find more posts tagged with

Accepted answers

Carson Penticuff

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.

MorganFrem

Success! This is the final formula that worked:

=SUMIF([POET Program]:[POET Program], "A", [Number of Attendees]:[Number of Attendees])

All comments

Carson Penticuff

A couple of notes:

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.

MorganFrem

@Carson Penticuff

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?

MorganFrem

Success! This is the final formula that worked:

=SUMIF([POET Program]:[POET Program], "A", [Number of Attendees]:[Number of Attendees])

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.