We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel functions


Newuser3477

Likes # 0

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

Like this post
scotty

Likes # 0

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

Like this post
Newuser3477

Likes # 0

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

Like this post
Woolwell

Likes # 0

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")

Like this post
FRANKMAC

Likes # 0

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

Like this post
Picklefactory

Likes # 0

FRANKMAC

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

Try this link Click Here

Like this post
Woolwell

Likes # 0

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

Like this post
FRANKMAC

Likes # 0

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

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Samsung Galaxy Tab S 8.4 review: The best iPad mini and Nexus 7 rival tablet around

IDG UK Sites

Which Mac? Complete Apple Mac buyers guide for 2014

IDG UK Sites

Mobile email is powerful and useful - but also hopelessly intrusive

IDG UK Sites

Samsung lights up London skyline with Midnight Rainbow