+1 for every letter "S"
Closed
bored2
Posts
1
Registration date
Saturday July 8, 2017
Status
Member
Last seen
July 8, 2017
-
Jul 8, 2017 at 11:00 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 12, 2017 at 11:04 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 12, 2017 at 11:04 AM
Related:
- +1 for every letter "S"
- Fnaf 1 download pc - Download - Horror
- Gta 1 download - Download - Action and adventure
- Fnia 1 - Download - Adult games
- Igi 1 download for pc - Download - Shooters
- Tentacle locker 1 - Download - Adult games
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 9, 2017 at 03:41 PM
Jul 9, 2017 at 03:41 PM
bored2, Good afternoon.
Your formula is a ARRAY formula.
Array formulas are often referred to as CSE (Ctrl+Shift+Enter) formulas because instead of just pressing Enter, you press Ctrl+Shift+Enter to complete the formula.
When you press Ctrl+Shift+Enter, Excel surrounds the formula with brace characters ({ }.
Try to do this and tell us if it worked for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Your formula is a ARRAY formula.
Array formulas are often referred to as CSE (Ctrl+Shift+Enter) formulas because instead of just pressing Enter, you press Ctrl+Shift+Enter to complete the formula.
When you press Ctrl+Shift+Enter, Excel surrounds the formula with brace characters ({ }.
Try to do this and tell us if it worked for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 11, 2017 at 08:32 AM
Jul 11, 2017 at 08:32 AM
Bored2, Good morning.
You can use a normal formula version with COUNTIF.
=SUM(COUNTIF(C5:C53,"S"),COUNTIF(F5:F53,"S"),COUNTIF(I5:I53,"S"))
If you are sure that in columns between columns C and I there is no possibility of any cells with S content, then try using: =COUNTIF(C5:I53,"S")
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You can use a normal formula version with COUNTIF.
=SUM(COUNTIF(C5:C53,"S"),COUNTIF(F5:F53,"S"),COUNTIF(I5:I53,"S"))
If you are sure that in columns between columns C and I there is no possibility of any cells with S content, then try using: =COUNTIF(C5:I53,"S")
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Thank you very much for your help. I was able to get the =COUNTIF(C5:I53,"S") formala to work and it works perfectly and does the job. The =SUM(COUNTIF(C5:C53,"S"),COUNTIF(F5:F53,"S"),COUNTIF(I5:I53,"S")) formula does not seem to work for me. Not sure why. I'm not getting an error and I am pressing Ctrl+Shift+Enter to complete.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 12, 2017 at 11:04 AM
Jul 12, 2017 at 11:04 AM
Bored2, Good morning.
As I said before:
"...You can use a normal formula version with COUNTIF. ..."
then you can not use Ctrl+Shift+Enter to complete.
Just press ENTER to complete this formula.
Try it and tell us if it is working.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
As I said before:
"...You can use a normal formula version with COUNTIF. ..."
then you can not use Ctrl+Shift+Enter to complete.
Just press ENTER to complete this formula.
Try it and tell us if it is working.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jul 10, 2017 at 05:55 PM