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?