I am attempting to do the following:

-Count number of rows where B2:B152 = “T” and G2:P152 contains any data.

I figured out that I cannot use COUNTIFS on data across multiple columns for a single criteria because when I changed my second criteria set to G2:G152, it picked up the data and gave me the result I was looking for. I am utilizing the Excel app on my iPad for work. Otherwise, I have a copy of excel on my home computer which should be the latest version as it’s through O365.

What would your recommendation be for approaching this?

By: Seth

Leave a Reply

Your email address will not be published. Required fields are marked *