Eratic formula results

    I have a formula which is a SUMIF that contains two ranges that are defined using an OFFSET. The formula is repeated 38 times in different cells and four of the formulas are returning the value of the referance number rather than the result of the SUMIF.
    I'm operating on Windows 2000 Professional and using Exvel 97 SR2.
    Help!

    Hi - welcome to the board!


    sure it's a failry straightforward problem. care to post the offending formula up & an indication of the data you've got....


    paddy

    Are you able to post the spreadsheet concerned?

    Robert Hind
    Perth - Western Australia

    via U2U:


    "=SUMIF(OFFSET($W$4,ActualDays,0):$W$370,R57,OFFSET($aa$4,ActualDays,0):$aa$370)
    I'm trying to summarise a forecast which has data for all the remaining days in this year by day of the week (DOW). R57 is the referance value for the day to sumarise for. Column W has the DOW value for each date. Column AA has the forecast values."

    Since the formula is working for some data and not for others it would be necessary to see the spreadsheet to determine the fault

    Robert Hind
    Perth - Western Australia

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login