Sum amounts from various sheets

[Suresh Kusunuri]

Hi All,

I have 12 sheets work book for Salaries. I wish to calculate total salary of each person during the year.

I used the following formula, but its showing "#REF".
=SUMPRODUCT(SUMIF(INDIRECT(""&Months&EMP),$C5,(INDIRECT("'"&Months&$O$5:$O$72))))
Months = List of Sheets
EMP = List of Employees
Range in RED = Salary Column (in Each Sheet)
$C5 = Employee's Name
Can any one help me in this calculation or suggest other formula

Thanks
Suresh

 

[Dave Patton]

Post 10 " Only thing is the source data should be same size in each month (No of employees).
To get result, I am inserting blank rows to reach the size of Data."

This is not very clear. Your earlier posts implied less that a 100 employees. If you have more than 100, increase the ranges to an appropriate number.
If you have less than 100 employees, the formula should work as written.

 

[Suresh Kusunuri]

Post 10 " Only thing is the source data should be same size in each month (No of employees).
To get result, I am inserting blank rows to reach the size of Data."

This is not very clear. Your earlier posts implied less that a 100 employees. If you have more than 100, increase the ranges to an appropriate number.
If you have less than 100 employees, the formula should work as written.

Thank you Mr. Dave.