Excel functions

  Newuser3477 11:26 19 Sep 2012
Locked

Please can someone remind me how to count the number of times a name or word appears in a spreadsheet column thanks Peter

  scotty 12:39 19 Sep 2012

COUNTIF should do it if it is a specific word you are looking for.

  Newuser3477 19:55 19 Sep 2012

Thanks I didn't make myself clear. It is the syntax which is defeating me. Could you give the syntax for the word chicken in column h and lines 3 to 20. Thanks

  Woolwell 22:54 19 Sep 2012

Which version of Excel are you using? if you click on the fx at the top of the spreadsheet and find countif it will tell you the syntax.

For your purposes you need =COUNTIF(H3:H20,"chicken")

  FRANKMAC 16:31 20 Sep 2012

Hi

I can see your question has been answered. what i was going to suggest was downloading an Excel spreadsheet from a guy named Peter Noneley i have used this sheet thousands of times, it not explains the functions, but gives working examples too. however i have just been to his site and the download is not working for some reason. this is the link below, maybe it would work for you.

http://www.hoffits.com/xlfdic/

if it doesnt work, then i would be more than happy to email to you.

hth

Mac

  Picklefactory 17:16 21 Sep 2012

FRANKMAC

I've used that for years too, and agree fully, it's a mine of useful info.

Try this link Click Here

  Woolwell 17:28 21 Sep 2012

I assume that with no replies that the OP has fixed the problem.

  FRANKMAC 19:40 21 Sep 2012

Picklefactory

Hi, just been to you link and its working fine, This is also an updated version to mine, so i have downloaded that too, Many Thanks.

Mac

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

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?