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
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
-
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
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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