How can I sum just numbers in a cell using letters or others symbo
 

How can I sum just numbers in a cell using letters or others symbo
 

Provide an example or two of what you want to do. HTH Otto
"JCPS" wrote in message
...

How can I sum just numbers in a cell using letters or others s
 

"Otto Moehrbach" wrote:

Provide an example or two of what you want to do. HTH Otto
"JCPS" wrote in message
...


IF I HAVE A ROW OF CELLS SAID A TO G FOR THE DAYS OF THE WEEK UP TO SUNDAYS, AND ON EVERY ROW SHOWS VACATIONS(L) OR SICK DAYS(S) DURING A PERIOD OF A WEEK OR TWO, BUT ON EACH CELLS IS WRITTEN A LETTER L OR S SHOWING TOGETHER TO THE LETTER THE HOURS ABSENCE ON THAT DAY, I WANT TO SUM OR ADD A TOTAL IN THE END OF A SEPARATED COLUMNS FOR EACH KIND OF ABSENCE AND AT THE SAME TIME SUBTRACT THAT SUB-TOTAL TO PREVIOUS BALANCE.

How can I sum just numbers in a cell using letters or others s
 

On Aug 10, 7:16 pm, JC-PS wrote:
"Otto Moehrbach" wrote:
Provide an example or two of what you want to do. HTH Otto
"JCPS" wrote in message
...

IF I HAVE A ROW OF CELLS SAID A TO G FOR THE DAYS OF THE WEEK UP TO SUNDAYS, AND ON EVERY ROW SHOWS VACATIONS(L) OR SICK DAYS(S) DURING A PERIOD OF A WEEK OR TWO, BUT ON EACH CELLS IS WRITTEN A LETTER L OR S SHOWING TOGETHER TO THE LETTER THE HOURS ABSENCE ON THAT DAY, I WANT TO SUM OR ADD A TOTAL IN THE END OF A SEPARATED COLUMNS FOR EACH KIND OF ABSENCE AND AT THE SAME TIME SUBTRACT THAT SUB-TOTAL TO PREVIOUS BALANCE.

So, something like this?: 8L 4S
There might be several ways to deal with this, you should post how
your data looks.

How can I sum just numbers in a cell using letters or others s
 

So, something like this?: 8L 4S
There might be several ways to deal with this,
you should post how your data looks.

Believe the OP posted afresh, re this discussion:
http://tinyurl.com/6cf3zg

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---