=SUM(A1:A4)+(COUNTIF(A1:A4,"8v")*8)+(COUNTIF(A1:A4 ,"8H")*8)...etc etc for
additional codes........
Vaya con Dios,
Chuck, CABGx3
"cbarcroft" wrote in message
...
I have a timesheet spreadsheet. Cell contents include hours and coding.
Example: 8 (8 hours regular pay-no letter) or 8V (8 hours vacation pay).
I
want to have a total at the end but my formula will only read the cells
that
don't have a letter after the number.
|