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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…