Sorry for all the mess. I did even cut a whole bunch out to try to simplify it but there's a lot of connections to figure out it's kinda difficult.
But it's simple, just the tops of columns C, D, and E. The three counters. They're compiling data for past 30/60/90 days.
C works, but D and E don't.
You'll notice they rely basically on the same formula as C just different columns.
I'm not so good at figuring out by tracing the calculations what's wrong with a formula but I think Excel said it had to do with the column in the table under C, yet the working formula under C also uses this column and didn't run into this #VALUE! error, so what's going on? Thanks
Bookmarks