Help in Sumproduct Formula

[amaan.khowaja]

Dear All,
i was working on a sheet where i need to extract report thru 4 filter, at some end all filters works fine except date filter and physician.

someone suggest that it will work thru sumproduct, it works but at the end i am stuck with date filter and physcian

specifically filter is disturbing the sheet when i need the report thru "ALL" option in custom report sheet.

please anyone help me in this sheet(attach for reference), its urgent if anyone can reply quickly.


The sheet is user friendly sheet(Inpatient) is main source data file and sheet(custom report) is the report i need thru different filters.

Best Regards
Amaan