May 29 2020 08:05 AM
I am attempting to search a sheet with three particular columns of interest: and I want to count up the number of instances that match … the last check is for a blank cell, and I can not see to get it to work.
what would be the correct way to get a valid answer ?
=COUNTIFS('CMDB Pull 5_28'!K:K,B2,'CMDB Pull 5_28'!D:D,"Symantec Endpoint Protection",'CMDB Pull 5_28'!F:F,"isblank")
May 29 2020 08:13 AM - edited May 29 2020 08:16 AM
Solutionby typing "isblank" it is checking if the cell contents say that text. Try using "" instead.
BTW you do know that countifs treats those conditions with an AND logic and therefore all those conditions must be true and not OR. I think that is what you want but wanted to mention it.
May 29 2020 08:19 AM
May 29 2020 08:35 AM
May 29 2020 08:13 AM - edited May 29 2020 08:16 AM
Solutionby typing "isblank" it is checking if the cell contents say that text. Try using "" instead.
BTW you do know that countifs treats those conditions with an AND logic and therefore all those conditions must be true and not OR. I think that is what you want but wanted to mention it.