Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: fcf

Search: Search took 0.00 seconds.

  1. Answers
    9
    Views
    717

    Hi I have changed the layout as you suggested,...

    Hi I have changed the layout as you suggested, please let me know if
    I have the format correct. I am now dealing with #ref error
  2. Answers
    9
    Views
    717

    this is working for me. The issue is now how to...

    this is working for me. The issue is now how to add a new range if you need it as in my example

    =SUM(OFFSET('warehouse-drivers'!S30,, -20-COUNTIF('warehouse-drivers'!C30:S30,"")))/20


    the...
  3. Answers
    9
    Views
    717

    Hi This is close to what I need, but it does not...

    Hi
    This is close to what I need, but it does not count back the 10 working days.
    We have
    16:s6 as the days that need to be checked for hours.
    N6 does not have any hours so the formaula should...
  4. Answers
    9
    Views
    717

    Hi I have attached a file hope that it explains...

    Hi I have attached a file hope that it explains what I am looking for
  5. hi are all the sheets you want the values to go...

    hi are all the sheets you want the values to go to in the same workbook?
  6. Answers
    9
    Views
    717

    how to count and sum a range of number

    I have a range of numbers that contain hours worked
    I need to calculate the total of 20 days worked
    not every cell in the range has a value, so I will need to keep adding vaules
    till I reach 20...
Results 1 to 6 of 6