ChatterBank1 min ago
Excel help please
6 Answers
I want a cell to automatically give me the total of how many cells in a worksheet contain a certain text. Eg, A holiday sheet with a guy's name in 6 places, say "Pete". I want a cell somewhere on the same sheet to tell me that he's already had 6 days and to update automatically when I put his name in the sheet again somewhere else when he books another day off or a week etc. TIA
Answers
Best Answer
No best answer has yet been selected by camioneur. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.You could use the COUNTIF function.
You have to specify the data range and the value that you are looking for.
Lets say that your data range is from cell A1 to cell D20 and you were looking for a count of the value Pete.
In a blank cell (outwith your data range) insert function :
=COUNTIF($A$1:$D$20, "Pete")
This formula will return the number of times Pete appears in your data range.
BW
You have to specify the data range and the value that you are looking for.
Lets say that your data range is from cell A1 to cell D20 and you were looking for a count of the value Pete.
In a blank cell (outwith your data range) insert function :
=COUNTIF($A$1:$D$20, "Pete")
This formula will return the number of times Pete appears in your data range.
BW