Pie Chart from Two Sheets

Hello

I have two sheets that are in effect the same - same column headers etc, but different source data feeding in.

I have a sheet summary on each. For example, if column 1 has a yes/no option, I do the following on each sheet:

=COUNTIF([1. Internal Process]:[1. Internal Process], "yes")

I now need to be able to combine the results into a pie chart on a dashboard so taking the 'yesses' from sheet a and adding them to the 'yesses' of sheet b to make a total.

I can do a report but that keeps the results for each separate and I just can't work out to combine them.

Can anyone help me please?

Thanks

Katie

Find more posts tagged with

Formulas

Reports

Dashboards

Accepted answers

All comments

Adam Murphy

You could calculate the COUNTIF for each sheet and add them together, which can be done within one cell using the + symbol between formulas, such as:

=COUNTIF([1. Internal Process]:[1. Internal Process], "yes") + COUNTIF({Sheet 2 Internal Process}, "yes")

Would that work?

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.