If this is your first visit, then welcome! Be sure to
check out the FAQ by clicking the
link above.Register here
so that you can post in the forums or comment on the articles.
My table is as such:
Column B: Names
Column E: Remainder
Column K: Criteria is True or False.
I need a formula that searches...
I don't think that COUNTIF itself will work, but it can be done using SUMPRODUCT, if that helps.
See my attachment....
thank you - the two formulas you provided are outside of my scope unless they are explained teacher to student
as a caveat to this - how do you...
I was also going to suggest:
What are all those AND(...)s doing in there?; they seem at first sight to be superfluous.
You could also try the likes of: