Solved Multiple TRUES on different sheets to show result TRUE

July 2, 2019 at 06:22:24
Specs: Windows 10
Hi all, I'm at the end of my tether with figuring this one out.

Essentially I need a version of this formula =IF(COUNTIF(X11:X390,"FALSE"),"FALSE","TRUE") but the cells are not in a linear range but dotted around the spreadsheet (potentially on other sheets also).

The above formula works great when the counted cells are all in 1 sheet and in a range however how do you select individual multiple cells?

I have tried...

=IF(COUNTIF(AND(J2,K8,L3),"FALSE"),"FALSE","TRUE") in addition to using J2&K8&L3 and the COUNTIFS formula but I can't seem to get this one right? Help?


See More: Multiple TRUES on different sheets to show result TRUE

Reply ↓  Report •

#1
July 2, 2019 at 08:52:36
If you don't have a lot of cells to reference the simplest way is to just add the COUNTIF()s something like

=COUNTIF(J2,"false") + COUNTIF(L3,"false") + COUNTIF(K8,"false")

How many cells do you need to count?

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
July 2, 2019 at 08:59:55
You could also just use the RANGE of cells from J2 thru K8 something like:

=COUNTIF(J1:L8,"False")

As long as no other cell in the range equals False you should get your count.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#3
July 2, 2019 at 09:40:08
✔ Best Answer
Your subject line says this...

"Multiple TRUES On Different Sheets To Show Result TRUE"

...yet all of your formulas seem to be counting FALSE's. That's a bit confusing.

In addition, I'm confused by what you are expecting the original formula to do. Unless we understand that, it's hard for us to find a solution to your actual question. Allow me to explain.

Your formula is going to return FALSE whenever there is 1 or more FALSE entries in the specified range. It doesn't matter if there is 1 FALSE or 380, this formula will return FALSE. Is that what you want?

=IF(COUNTIF(X11:X390,"FALSE"),"FALSE","TRUE")

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question