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?

If you don't have a lot of cells to reference the simplest way is to just addthe COUNTIF()s something like=COUNTIF(J2,"false") + COUNTIF(L3,"false") + COUNTIF(K8,"false")

How many cells do you need to count?

MIKE

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

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

Ask Your Question

Weekly Poll

Do you think Facebook should be allowed to move forward with the Libra currency?

Discuss in The Lounge

Poll History