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

"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.

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.

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
---