Hi Friends,
I am a looking for excel formula for my issue. I need to consolidate data from different sheets into the my consolidate sheet. It has multiple criteria, multiple column sum range, and multiple sheets. It might be combined of Sumifs+sumproduct+Indirect formula for this issue. Because the format is different from one sheet to another.
Please help me.
Regards,
Suresh.K
I am a looking for excel formula for my issue. I need to consolidate data from different sheets into the my consolidate sheet. It has multiple criteria, multiple column sum range, and multiple sheets. It might be combined of Sumifs+sumproduct+Indirect formula for this issue. Because the format is different from one sheet to another.
Please help me.
Regards,
Suresh.K