Dear,
Can anyone please help me to add value of below multiple sheets in summary sheets with the formula of =sumif(indirect(....?
I want to add these sheets value in one summary sheet which will have exact format. What formula can be used in summary sheet at B2 cell.
Your support will be highly appreciated.
Sheet1
A B C D
Can anyone please help me to add value of below multiple sheets in summary sheets with the formula of =sumif(indirect(....?
I want to add these sheets value in one summary sheet which will have exact format. What formula can be used in summary sheet at B2 cell.
Your support will be highly appreciated.
Sheet1
A B C D
Class | Jan | Feb | Mar |
Class 1 | |||
Class 2 | |||
Class 3 | |||
Sheet 2 | |||
Class | Jan | Feb | Mar |
Class 1 | |||
Class 2 | |||
Class 3 | |||
Sheet 3 | |||
Class | Jan | Feb | Mar |
Class 1 | |||
Class 2 | |||
Class 3 | |||
Sheet 4 | |||
Class | Jan | Feb | Mar |
Class 1 | |||
Class 2 | |||
Class 3 | |||
Sheet 5 | |||
Class | Jan | Feb | |
Class 1 |