# 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

#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?MIKEhttp://www.skeptic.com/

#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.MIKEhttp://www.skeptic.com/