Excel spreadsheet - count.

  hugh144 16:47 05 Dec 07
Locked

I've forgotten how to do this & I hope that someone can help. Using an Excel worksheet I need to count up the number of 'ticks' in each column on the sheet.

(It's all to do with counting up the menu choices for the office party)!!

  PalaeoBill 17:33 05 Dec 07

=COUNTIF(G3:G7,"?")

  PalaeoBill 17:34 05 Dec 07

I did have a tick symbol between the quotes but it is displaying as a question mark here.

  hugh144 17:56 05 Dec 07

Thanks Bill for your prompt reply - will try it in work tomorrow!

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017