Hi all,
I'm looking for a dynamic formula which populates tables in sheets 'Site 1', 'Site 2', and 'Site 4' .
The sheet name (Site #) is in cell A1 of each sheet to populate. Each sheet has 2 tables, either Northbound and Southbound, or Eastbound and Southbound (depending on the site). The direction for each table is the cell above that table (i.e. A2 for the first table in a sheet and A33 for the second table)
The 'Clean' sheet has all the data for each site, day and direction, and the hours of the day are along the columns.
I need a SumIf formula (or anything really) that populates each table depending on the time, day, direction, and site number.
Any help would be greatly appreciated!!
Bookmarks