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

  • Thread starter Thread starter JCPS
  • Start date Start date
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.
Click to expand...
 
So, something like this?: 8L 4S
There might be several ways to deal with this, you should post how
your data looks.
 
Back
Top