Hey...
I feel stupid posting this, but here goes. I need to make a conditional function, I think, that counts an item ONLY if it meets these conditions:
If column F2 to F120 is a "No", and column N2 to N120 is a "FALSE", then it is counted.
F2 to F12 is full of Yes and No, and N2 to N12 is full of TRUE and FALSE, so I want to see only the ones that are BOTH No AND FALSE. The current equatrion I am using is this:
=IF(COUNTIF('owssvr(1)'!F2:F120,"No")>0,COUNTIF('owssvr(1)'!N2:N120,"FALSE"),"")
But, this gives me only the number of FALSEs in the N2 to N120 column, seemingly disregarding the conditionality I am trying to make. I want it to only count how many are "No" in F2 to F120 that also have a "FALSE" in N2 to N120.
BTW, owssvr(1) is just the other tab that this is linking to, since I am keeping my equations and graphs on a separate page from my data. Anywas, any ideas?
Bookmarks