I seem to have stumped the Ozgridians. No responses to my post about calculating overtime in a pivot table. Perhaps a pivot table is the wrong approach. Please check out the original post and let me know if you have a better solution. Thanks!
See...
What is the syntax to lookup values in a pivot table? My pivot table has the columns product, monday, tuesday, wednesday, etc. Rows are product name and sum of sales by weekday.
I can use vlookup to search the cells as static references. There seems like there should be a a way to search as...