Formula for text in a cell and then total the amount on text

Closed
NicoleQA Posts 1 Registration date Monday March 13, 2017 Status Member Last seen March 13, 2017 - Mar 13, 2017 at 09:37 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 14, 2017 at 08:35 AM
Hello im trying to total the shfit allowance on timesheets eg:
In cell k7 they will leave blank if not claim shift allowance, but if they are then cell k7 will have a y.

So im wanting to total the number of y's in column k and then put the number of y's in cell D47

Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 14, 2017 at 08:35 AM
NicoleQA, Good morning.

Try to use:

D47 --> =COUNTIF(K1:K100, "y")

Adapt my reference cells at your reality.

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0