Forum Rules | Contact Forum Editor | Report a Post

Really stupid excel question

Josquius 17:35 02 Nov 2003

Locked

I have not used excel for ages and I should know how to do this however it seems I have forgotten somehow.
I wish to count the amount of occurances of a certain word.
e.g.

Columns 2,5,74,82,88,89 = WORD
all other columns 2-108 = something else.

What would I put in the = to count the amount of occurances of WORD
I really can't remember and excel help is no help as per usual.

Border View 17:41 02 Nov 2003

Dont have the answer but the question is not stupid. There are too many people in this forum only too willing to help. Feel sure that an answer will be forthcoming. Isn't it Woodchip who is excellent with Xcel?

VoG II 17:48 02 Nov 2003

Not stupid at all - in fact it's not at all obvious. Say you want to count the number of times WORD occurs in A1:A100 enter the following formula in a "spare" cell.

=COUNTIF(A1:A100,"WORD")

VoG II 17:54 02 Nov 2003

These examples may help click here

Josquius 19:49 02 Nov 2003

Thanks its worked, going to be doing a lot with excel in the following months :(

Josquius 20:11 02 Nov 2003

hmm now for stage 2 which is pretty hard not just a simple word-

I have a total of how many cells say WORD, now I need to add up the totals in the cells to the right of the WORD cells...

VoG II 20:13 02 Nov 2003

What cells are the totals in?

Let's say they are in D1 to D100

Then in a spare cell enter the formula

=SUM(D1:D100)

reddwarfcrew 21:06 02 Nov 2003

I think he needs to use the sumif.

ie he wants to total up the values in the cell to the right of any cells that contain 'word'

VoG II 21:10 02 Nov 2003

You may be right. I think that we should wait for Josquius to confirm or otherwise.

Border View 22:18 02 Nov 2003

VoG, my apologies, I got you confused with Woodchip. Knew there was an EXcel expert out there. Only remembered tonight. Sorry.

VoG II 22:23 02 Nov 2003

I'm happy for woodchip to answer the XL questions!