Previous Topic Next Topic

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

Closed
NicoleQA Posts 1 Registration date Monday 13 March 2017 Status Member Last seen 13 March 2017 - 13 Mar 2017 à 21:37
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 14 Mar 2017 à 08:35
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

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
14 Mar 2017 à 08:35
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response