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

Closed
Report
Posts
1
Registration date
Monday March 13, 2017
Status
Member
Last seen
March 13, 2017
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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

1 reply

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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