Transfering Data from two different sheets

[alexB588]

Ok so I am not an expert at excel, but I know basics on how to pull from different sheets.
That being said my issue is:
I have Sheet 1 (Builder List) that contains all the builders that I work with, I have an empty column that is labeled "Total YTD Price". I want to transfer data from Sheet 2(Project Tracker)Column F that is labeled "Total Cost" give me a running YTD total.

Example.) Sheet 1(Builder List), B37 is my builder "Great Northern Construction". I want all the price data from sheet 2 (Project Tracker) for all of my Great Northern Construction projects to have a running total on sheet 1 (Builder List).


I will eventually do that for all my builders but I cannot figure out the formula on how to do it.

Any feedback would be appreciated.

PS I wish you could attached excel files here

 

[FDibbins]

Take a look at SUMIF() for this

=sumif('sheet2'!B:B,A2,'sheet2'!F:F)

Pretty much what this says - in case I have the references wrong - is as follow...
find all references in Sheet2 column A for the criteria specified in A2 (on sheet1), and ad up all values for those rows, from column F

 

[alexB588]

Boom, you rock. Had to do a little adjusting. Works like a charm
=SUMIF('Project Tracking'!A:A,B37,'Project Tracking'!F:F)

 

[FDibbins]

Good stuff, happy to help