Ok .Here I have attached file with two more worksheets namely L1 and P1 besides L3 and P3.In L1 same functions is copied from L3 sheet but referencing worksheet from P3 is altered to P1 but results are not properly extracted.So,kindly see why there is zero even if there is data in P1 worksheet.Red highlighted tab L1 and P1 should be looked upon whereas L3 and P3 are fine.
I am very much surprised why it is not working when adding the worksheets and changing the worksheet references.Plz see what is the cause of issue.I have many other sheets to add.
Bookmarks