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

  • 2
    I suppose you know your spreadsheets in detail, so your explanation makes sense to you, but you'll have to reformulate it for people who never saw you spreadsheets if you want your question answered. May 15, 2015 at 1:25
  • Sheet 1 A. B. 3/4 conduit. Sheet 2 totals 3/4 coupling. 3/4 connector. Sheet 2 A. B 3/4 coupling. 5 3/4 conduit. 8 3/4 connector. 10
    – Eric Fudge
    May 15, 2015 at 1:36
  • i would like column 2b on sheet 2 to recognize a WORD and then take the total of 2c and place it on sheet 1 in the totals column With the matching Word.
    – Eric Fudge
    May 15, 2015 at 1:42
  • I understand exactly what your up to, BUT the question really isn't answerable at this point. I would suggest screenshots might help.
    – Tyson
    May 15, 2015 at 1:46
  • Don't put pieces of your question into comments; edit your question to clarify it.  If you can't post screenshots, type in representations of your sheets, as was done here and here. May 15, 2015 at 8:41

1 Answer 1


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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .