Hi,
I'm making a shedule calculating number of days with function (row 4) with number of hours/function (row 2).
=(G4*G2)+(H4*H2)+(I4*I2)+....
Colum marked PROBLEM
How can i get excel to do the same calculation for 2 rows for all functions G to AK. i.e =(G4*G2)+(H4*H2)+(I4*I2) + ... until (AK4*AK2)
Solved by X. C. in 21 mins