Rizwan Ahmed

Rizwan Ahmed

  • NA
  • 80
  • 12.5k

Search date with multiple criteria and in mutliple sheets in excel

Jul 22 2021 6:12 PM

I create a sheet with 32 sheet, 30 sheets are dates in which daily basis works updated in these 30 sheets have Location name, Date & Amount column. And 1 sheet is Summary, in which I want to view on which date & which location is not paid if location is not paid show blank or NotAvailable and if Location had paid amount then show both dates in which location sent and i received on.
I use below formula but it is 


Answers (1)