Ok I'll try my best to explain this. I have my totals all set up for my electrical fittings on sheet 1. I would like to be able to take my entire excel spread sheet from my estimating program, place it on sheet two and have the totals go to their appropriate cells. For example. When I put my totals on sheet 2. I would like column A to see 3/4"conduit and take the total of column B 55ft and place it on Sheet 1 in the 3/4" totals cell. The only problem is everytime I use sheet 2 the parts and pieces will be in different orders so it has to be by name not designated cell. Thanks and I hope someone has an answer
Asked
Active
Viewed 52 times
1 Answers
0
If I understand correctly this should work.
The formula would go on sheet 1 column b =sumif(Sheet2!A1:A3,A1,Sheet2!B1:B3)
Sheet 1: A | B
3/4 conduit | =sumif(sheet2!A1:A3,A1,Sheet2!B1:B3)
Sheet 2: A | B
3/4 coupling| 5
3/4 conduit | 8
3/4 connector| 10
Sheet 1: B1 should = 8
Carrie
- 31