Hi,
I have a spreadsheet where I have unit sizes in place based on page sizes. eg. 48 pages, 24 pages, 12 pages, 8 pages located in cells A2, B2, C2 and D2. I want to be able to sum the total of these columns based on the number of units in each column. So if 48 pages has 1 unit, 24 pages has 0 units, 12 pages has 0 units and 8 pages has 2 units the sum would be 48x1 +24x0 + 12x0 + 8x2 = 64.
I have worked this out for each row as =SUM(A3*A2,B3*B2,C3*C2,D3*D2) but there are 80 rows and I was wondering if there was a simpler method. I have embedded an image to help illustrate the spreadsheet.
Section_Size.jpg
Kindest regards
Bookmarks