calculate the sum of characters in a cell

Do you mean if you have "12345" in a cell you want 1+2+3+4+5?? In this case
this formula array entered (Ctrl+Shift+Enter) will work:

=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

If this isn't what you wanted try explaining a little better or posting some
examples.
--
Regards,
Dave


"Nat" wrote:

calculate the sum of characters in a cell

Thank you for your reply

I'm looking to calculate how much alphabetical characters I have in each cell
"David Billigmeier" wrote:

Do you mean if you have "12345" in a cell you want 1+2+3+4+5?? In this case
this formula array entered (Ctrl+Shift+Enter) will work:

=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

If this isn't what you wanted try explaining a little better or posting some
examples.
--
Regards,
Dave


"Nat" wrote:

calculate the sum of characters in a cell

Should numerical values and symbols be counted as well, e.g. should the 1,8,3
and "-" be counted in "A1FD-83"? If so all you need is =LEN(A1)

If not you need something a little more complicated. I see you said
"alphabetical characters" so here is an example counting only the values
appearing in the English alphabet (A through Z):

=SUMPRODUCT(--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )=65),--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )<=90))

If this is still not what you wanted please post some examples.
--
Regards,
Dave


"Nat" wrote:

Thank you for your reply

I'm looking to calculate how much alphabetical characters I have in each cell
"David Billigmeier" wrote:

Do you mean if you have "12345" in a cell you want 1+2+3+4+5?? In this case
this formula array entered (Ctrl+Shift+Enter) will work:

=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

If this isn't what you wanted try explaining a little better or posting some
examples.
--
Regards,
Dave


"Nat" wrote:

calculate the sum of characters in a cell

Thank you "LEN" this is what I'm looking for

"David Billigmeier" wrote:

Should numerical values and symbols be counted as well, e.g. should the 1,8,3
and "-" be counted in "A1FD-83"? If so all you need is =LEN(A1)

If not you need something a little more complicated. I see you said
"alphabetical characters" so here is an example counting only the values
appearing in the English alphabet (A through Z):

=SUMPRODUCT(--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )=65),--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )<=90))

If this is still not what you wanted please post some examples.
--
Regards,
Dave


"Nat" wrote:

Thank you for your reply

I'm looking to calculate how much alphabetical characters I have in each cell
"David Billigmeier" wrote:

Do you mean if you have "12345" in a cell you want 1+2+3+4+5?? In this case
this formula array entered (Ctrl+Shift+Enter) will work:

=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

If this isn't what you wanted try explaining a little better or posting some
examples.
--
Regards,
Dave


"Nat" wrote:

calculate the sum of characters in a cell

Is there a way to count the numerical values and symbols and even spaces
except the spaces after the sentence?

"David Billigmeier" wrote:

Should numerical values and symbols be counted as well, e.g. should the 1,8,3
and "-" be counted in "A1FD-83"? If so all you need is =LEN(A1)

If not you need something a little more complicated. I see you said
"alphabetical characters" so here is an example counting only the values
appearing in the English alphabet (A through Z):

=SUMPRODUCT(--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )=65),--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )<=90))

If this is still not what you wanted please post some examples.
--
Regards,
Dave


"Nat" wrote:

Thank you for your reply

I'm looking to calculate how much alphabetical characters I have in each cell
"David Billigmeier" wrote:

Do you mean if you have "12345" in a cell you want 1+2+3+4+5?? In this case
this formula array entered (Ctrl+Shift+Enter) will work:

=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

If this isn't what you wanted try explaining a little better or posting some
examples.
--
Regards,
Dave


"Nat" wrote:

calculate the sum of characters in a cell

What sentence are you talking about? Is that the contents of your cell? If
so, is the end of your sentence a period? Do you want just numerical,
symbols and spaces counted? Or do you want alphabetic characters counted as
well (e.g. A through Z)? So many questions, I am confused again what you
mean, sorry. Please post a couple of examples...


--
Regards,
Dave


"Nat" wrote:

Is there a way to count the numerical values and symbols and even spaces
except the spaces after the sentence?

"David Billigmeier" wrote:

Should numerical values and symbols be counted as well, e.g. should the 1,8,3
and "-" be counted in "A1FD-83"? If so all you need is =LEN(A1)

If not you need something a little more complicated. I see you said
"alphabetical characters" so here is an example counting only the values
appearing in the English alphabet (A through Z):

=SUMPRODUCT(--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )=65),--(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )<=90))

If this is still not what you wanted please post some examples.
--
Regards,
Dave


"Nat" wrote:

Thank you for your reply

I'm looking to calculate how much alphabetical characters I have in each cell
"David Billigmeier" wrote:

Do you mean if you have "12345" in a cell you want 1+2+3+4+5?? In this case
this formula array entered (Ctrl+Shift+Enter) will work:

=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

If this isn't what you wanted try explaining a little better or posting some
examples.
--
Regards,
Dave


"Nat" wrote:

calculate the sum of characters in a cell