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?
Try:
=Sumproduct(--(F2:F120="No"),--(N2:N120=FALSE))
where FALSE is result fo Boolean formula... if not, enclose False in double quotes too.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks