Countif / sumif ?

Paul_Arnaud

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?

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.