August 15, 2018
I am doing a summary report for monthly flights per project and applying the SUMIF formula.
It works for the first 3 months but not for the rest
I have checked the data and I don't know how it does not work
I am trying to set it up so the summary report is updated every time new data is entered.
Could you please help?
June 25, 2016
From what I can see, the Project No in the Summary by Project sheet does not match that of the April sheet etc.
There are extra trailing space after the Project No in the April sheet but not in the Summary sheet.
e.g. S632 have 2 extra trailing space in the April sheet. You should remove these extra space.
Hope this helps.