RE: Using SUM function to count hours BUT ignore Letters?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Will,
could you give an example of what you try to sum and the complete formula
you have

"Will H, England" wrote:

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

Relevant Pages

  • Re: How do I calculate times over multiple records?
    ... I got the code to run but not with the SUM in place. ... doing a sum on the DateDiff Calculation. ... query) and therefore runs once for each row returned by the outer query. ... Excluding Weekends and Holidays is more complex. ...
    (microsoft.public.access.queries)
  • Adding over 30 worksheets in a workbook
    ... Happy Holidays! ... How can I SUM the value of the same cell located in over 30 ... worksheets in the same workbook to get a grand total of all those values? ...
    (microsoft.public.excel.newusers)
  • Re: Networkdays including Saturday?
    ... From what I can see that sum only works out the days not the hours, ... DayEnd= 17:30:00 ... DayStart= 09:00:00 ... Including Saturdays but excluding Sundays & Holidays. ...
    (microsoft.public.excel.worksheet.functions)
  • Sum If
    ... I record by week the vacations days and ... sick days. ... In cell A I would like to get the sum of all the cells that start ...
    (microsoft.public.excel.misc)
  • Re: Rachels New Thread
    ... I feel so sick, I feel like barfing all over the place, barfing my ... tried to meet Bob Dylan, EVAR, ARE YOU CRAZY, MEET BOB DYLAN, DO YOU ... I'm all alone over the holidays. ...
    (rec.music.dylan)