G
Guest
How do I accomplish this. I have 2 sheets in one workbook. The first sheet
is:
BP# Total$ Misc
1 0
2 0
3 0
The second sheet is
BP# Phase Qunatity Unit Rate Subtotal
3 Demo 3 2 6
6 Drywall 2 2 4
3 Safety 5 1 5
i would like the TOTAL$ cell in the first sheet to be the SUM of all
subtotals in the second sheet where the BP# of the second sheet matches the
BP# of the row of that same TOTAL$ row in the first sheet.
So in this short example then the TOTAL$ for BP#3 in the first sheet would
equal $11.
Any help would be greatly appreciated. I am stuck.
Frank M.
is:
BP# Total$ Misc
1 0
2 0
3 0
The second sheet is
BP# Phase Qunatity Unit Rate Subtotal
3 Demo 3 2 6
6 Drywall 2 2 4
3 Safety 5 1 5
i would like the TOTAL$ cell in the first sheet to be the SUM of all
subtotals in the second sheet where the BP# of the second sheet matches the
BP# of the row of that same TOTAL$ row in the first sheet.
So in this short example then the TOTAL$ for BP#3 in the first sheet would
equal $11.
Any help would be greatly appreciated. I am stuck.
Frank M.