Ok to make a long story short I downloaded this Gage Tracking excel work book. Of course because I have office 2003 I had all kinds of formula issues when I opened the 2007 file. For some reason it has macros which I do not know how to turn off so I disable them as it would like to link to a file that is not there. Fine I will choose disable not a big deal. I was finally able to link everything together otherwise except the first overall view page. Basically this is supposed to list all my gages that are over due for calibrations, how many are due for calibration in 30 days, 60 days, and 90 days. The equipment list (on the InstrumentLog tab) lists out all of the gages, whether or not they are In Service, the last day they were calibrated, and the next due date. First I had #NAME errors then I changed the _xlfCOUNTIFS to SUMPRODUCT and now I am getting #VALUE errors. Below is the formula for both Overdue and Due in 30 Days:

=SUMPRODUCT(InstrumentLog!F2:F47,"In Service",InstrumentLog!K2:K47,"<"&TODAY())

=SUMPRODUCT(InstrumentLog!F2:F47,"In Service",InstrumentLog!K2:K47,""&TODAY(),Instrume ntLog!K2:K47,"<="&TODAY()+30)

InstrumentLog is the sheet that lists out all of the gages and what I said above. F2:F47 is the column that says whether or not the gage is In Service or Out of Service and K2:K47 lists the Next Calibration Due Dates.


Any help anyone could give would be greatly appreciated!!