exclude blank cells
1 Topic
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. ="# of Other Tech Tickets:"&COUNTIF(A5:A279, "<>Tech Name") In the above formula, I'm getting the following result. I wish I was efficient as the number below.. In actually I only worked 27 total, 14 of my own an 13 of other techs (different names), so I'm trying to exclude my name (which I had accomplish, I believe) but it's counting blank/empty cells. # of Other Tech Tickets:261 Any input is greatly appreciated! I can't seem to figure this out.Solved1.8KViews0likes6Comments