Sum different alphabets in an excel range.
Solved/Closed
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
-
18 Sep 2015 à 12:34
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 20 Sep 2015 à 11:08
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 20 Sep 2015 à 11:08
Related:
- Excel áπ∞„çäëøî„åó
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
5 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
20 Sep 2015 à 11:08
20 Sep 2015 à 11:08
tahir147, Good afternoon.
I feel happy to help you.
I wish you a good week of work full of health and happiness to you and your whole family.
Best regards!
--
Belo Horizonte, Brasil.
Marcílio Lobão
I feel happy to help you.
I wish you a good week of work full of health and happiness to you and your whole family.
Best regards!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
18 Sep 2015 à 14:32
18 Sep 2015 à 14:32
tahir147, Good afternoon.
Your request is very confused.
Initially, you can not add letters, only numbers.
You can COUNT letters if this is the case.
Please, explain with examples what do you want to do.
Your request is very confused.
Initially, you can not add letters, only numbers.
You can COUNT letters if this is the case.
Please, explain with examples what do you want to do.
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
19 Sep 2015 à 10:21
19 Sep 2015 à 10:21
Good Evening .Sir,Mazzaropi.
I want to creat a table for my office work ......its contents like this
thirty or thirty one colums by monthwise......i put in every cell "P" "C" "D" or "CP"
and i want to count after the month that how many "P" "C" "D" or "CP" I entered in the whole month.....and if "CP" i entered in one cell its shows in total sepretly with C....and ,..P
I hope you understand please hlelp me.....
I want to creat a table for my office work ......its contents like this
thirty or thirty one colums by monthwise......i put in every cell "P" "C" "D" or "CP"
and i want to count after the month that how many "P" "C" "D" or "CP" I entered in the whole month.....and if "CP" i entered in one cell its shows in total sepretly with C....and ,..P
I hope you understand please hlelp me.....
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
19 Sep 2015 à 10:34
19 Sep 2015 à 10:34
if you can,t understan pleas send me you email i will send you preapred table with exemle in excel file.
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
19 Sep 2015 à 10:57
19 Sep 2015 à 10:57
tahir147, Good morning.
Now your explanation make sense for me, thanks.
Suppose:
A1:AE1 --> 31 days of month
A2:AE2 --> YOUR DATA
To COUNT how many times a letter appears you can use:
=COUNTIF($A$2:$AE$2,"C")
I did an example for you:
http://speedy.sh/fp8GN/19-09-2015-Example-tahir147.xlsx
"...and if "CP" i entered in one cell its shows in total sepretly with C....and ,..P ..."
This part I can't understand what you need.
Take a look at my example and tell us if it worked for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Now your explanation make sense for me, thanks.
Suppose:
A1:AE1 --> 31 days of month
A2:AE2 --> YOUR DATA
To COUNT how many times a letter appears you can use:
=COUNTIF($A$2:$AE$2,"C")
I did an example for you:
http://speedy.sh/fp8GN/19-09-2015-Example-tahir147.xlsx
"...and if "CP" i entered in one cell its shows in total sepretly with C....and ,..P ..."
This part I can't understand what you need.
Take a look at my example and tell us if it worked for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
19 Sep 2015 à 12:27
19 Sep 2015 à 12:27
Thanks Mazzaropi Sir,
its good but one little thinks that I can,t adopt this function that for example if i entered in a range cell CP or CD its dos,t count with C , P, and D..
i want to count all total no of letters although if in one cell have more then one letter.
thanks for reply, you can solve my problem..
its good but one little thinks that I can,t adopt this function that for example if i entered in a range cell CP or CD its dos,t count with C , P, and D..
i want to count all total no of letters although if in one cell have more then one letter.
thanks for reply, you can solve my problem..
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
19 Sep 2015 à 13:10
19 Sep 2015 à 13:10
I tell you compleet story,
Letters P,C,B,G,F are showing the cetogory of empty bags like
P= Plastic Bag ,C=Canves Bag ,B= Blue Bag ,G= Green BAg ,F= foreign Bag
thees bags are recived to my main branch from different sub offices daily in wohole month,
Countif funtion is useful when I recived only one bag from thees cetogoreis daily but for example if sub office send both C (canves bag) and P (plastic bag) in one day so then how i count this at the end of the month,
I hop you understand
Letters P,C,B,G,F are showing the cetogory of empty bags like
P= Plastic Bag ,C=Canves Bag ,B= Blue Bag ,G= Green BAg ,F= foreign Bag
thees bags are recived to my main branch from different sub offices daily in wohole month,
Countif funtion is useful when I recived only one bag from thees cetogoreis daily but for example if sub office send both C (canves bag) and P (plastic bag) in one day so then how i count this at the end of the month,
I hop you understand
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
19 Sep 2015 à 13:35
19 Sep 2015 à 13:35
tahir147, Good afternoon.
"...i want to count all total no of letters although if in one cell have more then one letter..."
In this case you can try this one:
Matricial Formula
=SUM(LEN(A2:AE2))
Press SHIFT + CTRL + ENTER at final
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...i want to count all total no of letters although if in one cell have more then one letter..."
In this case you can try this one:
Matricial Formula
=SUM(LEN(A2:AE2))
Press SHIFT + CTRL + ENTER at final
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
19 Sep 2015 à 14:02
19 Sep 2015 à 14:02
=SUM(LEN(A2:AE2)) this funtion dos,t work for me
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
20 Sep 2015 à 08:57
20 Sep 2015 à 08:57
thair147, Good morning.
With this new specification we will need a different formula.
Try to use:
For a specific CODE.
=SUMPRODUCT((LEN($A$2:$AE$2)-LEN(REPLACE($A$2:$AE$2;"C";""))))
For a CODE in a CELL.
=SUMPRODUCT((LEN($A$2:$AE$2)-LEN(REPLACE($A$2:$AE$2;J6;""))))
NEW model with a new formula:
http://speedy.sh/vJsCQ/20-09-2015-en-Kioskea-Counting-Codes-OK.xlsx
Please, do your tests and tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
With this new specification we will need a different formula.
Try to use:
For a specific CODE.
=SUMPRODUCT((LEN($A$2:$AE$2)-LEN(REPLACE($A$2:$AE$2;"C";""))))
For a CODE in a CELL.
=SUMPRODUCT((LEN($A$2:$AE$2)-LEN(REPLACE($A$2:$AE$2;J6;""))))
NEW model with a new formula:
http://speedy.sh/vJsCQ/20-09-2015-en-Kioskea-Counting-Codes-OK.xlsx
Please, do your tests and tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
20 Sep 2015 à 10:30
20 Sep 2015 à 10:30
Good Evening Mazzaropi Sir,
I did same code but it give an eror showing full black highlighted in second part of fuction $AE$2 in above specific both codes.
I did same code but it give an eror showing full black highlighted in second part of fuction $AE$2 in above specific both codes.
tahir147
Posts
8
Registration date
Friday 18 September 2015
Status
Member
Last seen
20 September 2015
20 Sep 2015 à 10:50
20 Sep 2015 à 10:50
Thanks Sir, I got it ,
actually You use word REPLACE in above file instead of SUBSTITUTE.
whan i see fuction in excel file i got it and it work parfectly that i want....Now I can make my table for my office ....thanks allott sir ...Hope you wiil help me in future as well.....Good By
actually You use word REPLACE in above file instead of SUBSTITUTE.
whan i see fuction in excel file i got it and it work parfectly that i want....Now I can make my table for my office ....thanks allott sir ...Hope you wiil help me in future as well.....Good By
