Forum Discussion
Solved
nested logical tests to get a single number answer
I am looking to solve the following problem is creating a operative formula: I wish to count how many 'things' there are in my spreadsheet which are not blank in column O and not blank in column R a...
Philip_Spencer Then below formula should work for you.
=COUNTIFS(L:L,"<>",O:O,"<>",R:R,"<>")
Thank you for your reply.
I have not expressed my problem well.
My result should only count the number of 'things' which are not blank in all three of these columns, so not blank is O AND not blank in R AND not blank in L.
The result must count what things satisfy all three criteria.
Philip_Spencer Then below formula should work for you.
=COUNTIFS(L:L,"<>",O:O,"<>",R:R,"<>")- Thank you Harun, you have answered my question and taught me how to use the function effectively.