W
Will H, England
Hi I use sum functions to total hours in rows and previously used coloured
cells for holidays, vacations and sick etc. (not ideal!) Ive started using
the IFCOUNT function to countr the number of holidays etc taken but the
problem I have now is the =SUM(cell:cell) formulas I have are giving errors
How can I make the SUM formulas ignore the letters?
thanks
Will.
cells for holidays, vacations and sick etc. (not ideal!) Ive started using
the IFCOUNT function to countr the number of holidays etc taken but the
problem I have now is the =SUM(cell:cell) formulas I have are giving errors
How can I make the SUM formulas ignore the letters?
thanks
Will.