Hi there, no i get 315.24
Basically i want if there is a '1' or any number in the columns G, I, K etc on the 'Rate Buildup' page, I want excel to add that numbr of times ie '1' '2' etc etc, the number in the corresponding column on the 'material page', i.e. slopes i.e. 1 x 100 + 1 x 110 + 2 x 120 + 1 x 20 = 420, then divided by R9 (1.64) = 286.58 + S15 (10%) = 315.24.
Bookmarks