Hi,
I have used Sumif and indirect in the attached excel sheet.
I noticed that the formula used in the same sheet where the data used for calculation works fine. But if use the same sumif and indirect i am getting 'ZERO'
Please refer to formula in sheet 1 and sheet 2.
Many thanks...
Regards,
Suresh Kumar K
Bookmarks