Anotehr Excel question

  exdragon 14:42 18 Mar 2006
Locked

Hi - I'm entering on a spreadsheet details from people who can live in any one of 50 countries.

Is there a way I can keep a running total of the no. of entries for each country, by having one cell per country, and the number therein will increase by 1 each time I enter data for that particular country?

i know I can do a data sort and then count, but if there's a simple formula, it'd be better! Or is it a case of a sledgehammer to crack a walnut?

  exdragon 14:43 18 Mar 2006

I'm incapable of typing 'the' - sorry!

  VoG II 14:46 18 Mar 2006

=COUNTIF(A1:A100,"UK")

  exdragon 14:51 18 Mar 2006

VoG™ - thanks, works a treat!

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Aardman's new YouTube channel to share the work of independent animators

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017