Forum Discussion

ulken2019's avatar
ulken2019
Copper Contributor
Jul 01, 2019
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...
excel
exclude blank cells
formula
  • Haytham Amairah's avatar
    Haytham Amairah
    Jul 01, 2019

    ulken2019

     

    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

JwanSha's avatar
JwanSha
Copper Contributor
Jul 01, 2019

ulken2019 

 

Hello,

 

If I understand correctly, you want to make sure that the "0's" are not counted bc it can have an effect on the tasks completed. Please see the link below. 

https://www.google.com/search?q=how+to+exclude+empty+cells+in+excel&rlz=1C1GCEU_enUS826US826&oq=how+to+esxclude+empty+ce&aqs=chrome.1.69i57j0l5.6338j0j7&sourceid=chrome&ie=UTF-8#kpvalbx=1

Resources