Excel spreadsheet - count.

  hugh144 16:47 05 Dec 2007
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 2007

=COUNTIF(G3:G7,"?")

  PalaeoBill 17:34 05 Dec 2007

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

  hugh144 17:56 05 Dec 2007

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

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

Camera tips to take better iPhone photos

Comment transformer un iPhone en borne Wi-Fi ?