Forum Discussion
Solved
Excel Forumla to exclude empty cells.
All, I am using the following formula on my excel worksheet and it is including blank cells. I was wondering if anyone could assist on helping me modify it to ignore/disregard the blank cells...
Hi,
The best way to do so is to use COUNTIFS (with s) as below instead of COUNTIF, which allows you to add more than one criteria.
="# of Other Tech Tickets: "&COUNTIFS(A1:A279,"<>Tech Name",A1:A279,"<>"&"")
Hope that helps
Hi,
The best way to do so is to use COUNTIFS (with s) as below instead of COUNTIF, which allows you to add more than one criteria.
="# of Other Tech Tickets: "&COUNTIFS(A1:A279,"<>Tech Name",A1:A279,"<>"&"")
Hope that helps
