I've been working diligently on this reports spreadsheet and I'm almost there, but I've run into a snag with the following (admittedly long & clunky) formula:
Formula:Please Login or Register to view this content.
I know, I know, it's a beast, but it's the only way I could figure-out how to deal with changing/shifting items in the first column from day to day. Everything was working great until I figured out that at some point an item would be added mid-month which means on the Daily Reports there would be some days that would not include the full referenced list in the monthly report formula. For example, if I go to any random day and delete one item, I get the dreaded #N/A error on the Monthly Report.
I've tried incorporating ISERROR in the formula, but that just gives me a value of 0 in the monthly report. What I need is a way for the formula to simply skip the days it doesn't find that particular value and tabulate the rest of the days of the month for that line item.
Hopefully, I made myself clear. Thanks in advance for any help, even if it's not a full solution. I'm a bit of a hack, but can figure things out if pointed in the right direction.
Bookmarks