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 = WORDall other columns 2-108 = something else.What would I put in the = to count the amount of occurances of WORDI really can't remember and excel help is no help as per usual.
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?
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")
These examples may help click here
Thanks its worked, going to be doing a lot with excel in the following months :(
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...
What cells are the totals in?Let's say they are in D1 to D100Then in a spare cell enter the formula=SUM(D1:D100)
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'
You may be right. I think that we should wait for Josquius to confirm or otherwise.
VoG, my apologies, I got you confused with Woodchip. Knew there was an EXcel expert out there. Only remembered tonight. Sorry.
I'm happy for woodchip to answer the XL questions!
This thread is now locked and can not be replied to.
Motorola Moto G6 review: Hands-on
The best smart speaker: Apple HomePod vs Google Home vs Amazon Echo
Les meilleurs jeux gratuits pour Mac (2018)
© Copyright 2018 IDG UK. All Rights Reserved.