0
I am unable to shorten an Excel formula I am using in an Excel database. I've googled it, but this appears to be already the shortest way from the first page on Google.
=COUNTIF(K:K,"Busy")+COUNTIF(K:K,"Hangup")+COUNTIF(K:K,"Stopped")+COUNTIF(K:K,"Voicemail")+COUNTIF(K:K,"Wrong Number")+COUNTIF(K:K,"No Answer")+COUNTIF(K:K,"IP Phone Offline")+COUNTIF(K:K,"Call accepted")
The formula isn't pretty and, on the report I need to produce about this database, it stands out as looking quite simply horrible.
Can anyone give me a pointer in the right syntax OR send through the correct way to do this but annotated so I can learn how to do it in the future?
Thanks!
Edd
Thank you very much for your answer! The top one answer helps a lot as the criteria is around 500 rows of a few thousand row spreadsheet. Thanks again! I'd upvote it but unfortunately I have less than 15 reputation! – Edward Haigh – 2014-10-20T15:29:35.657