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

J

JC-PS

Otto Moehrbach said:
Provide an example or two of what you want to do. HTH Otto


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

Spiky

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top