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

Kodipady's avatar
Kodipady
Iron Contributor
Jul 01, 2019

ulken2019 , please try following to exclude blanks

="# of Other Tech Tickets:"&(COUNTIF(A1:A275, "<>Tech Name")-COUNTBLANK(A1:A275))

Resources