Countif / sumif ?

Hi everyone,

I'm looking for a formula which will give the number I obtain when I filter such as :

I want to know how much "Club Readiness" Online we've when "Current System" column is one of the 2 values selected (let's call them "X" and "Y").

I tried with COUNTIFS, and with COUNTFS with IF function nested, but without good results.

Any ideas?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You will need a COUNTIFS with an OR function.

=COUNTIFS([Current System]:[Current System], OR(@cell = "A", @cell = "B"), [Club Readiness]:[Club Readiness], @cell = "Online")

Paul_Arnaud

Hi Paul,

Thanks for your answer. I should have been more precise for my question since this formula will be added to a summary sheet in order to project data into a dashboard. Therefore, @cell doesn't work.

So, on sheet A I've the columns with the data shown in my previous post and formula will be implemented in a summary sheet.

I tried the followin without any good results : =IF({Remote Surveillance Master FR Range Club Readiness} = "Online", COUNTIFS({Remote Surveillance Master FR Range Current system}, "ARC RS", {Remote Surveillance Master FR Range Current system}, "ARC TG (RS Lite)), "").

Any idea?

Paul Newcome

You still need the @cell references. You would just change the ranges to cross sheet references and use the same syntax as I have in my last post.

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.