Hi,
I am working on a report that needs to maintain a running total of rail cars shipped each day only for the month then start over. I have attached an example report. On all 5 tabs, MON-FRI in cell S19 is where these running total needs to appear based on C19 of every sheet. I have tried different sumifs with date range formulas, but everything I have tried comes up blank or #value. The date is located in the top of each tab in H2.
Regards,
Kandi
I am working on a report that needs to maintain a running total of rail cars shipped each day only for the month then start over. I have attached an example report. On all 5 tabs, MON-FRI in cell S19 is where these running total needs to appear based on C19 of every sheet. I have tried different sumifs with date range formulas, but everything I have tried comes up blank or #value. The date is located in the top of each tab in H2.
Regards,
Kandi
