Need Assistance with Spreadsheet Formula

[wgregoryjr]

Fairly new to excel. Wanted to know if it is possible to have a formula that looks at a particular column for specific value (i.e. City Name) and for every instance of that it would display a value in another cell on that same row.

For example:

Each row has the following fields: Date, Name, Location, Total
I'm wanting to know if anywhere in the worksheet in the Location column if 'New York' is present , can you have it add up the values in the 'Total' cells.

[TABLE="width: 489"]
<colgroup><col width="110"><col width="180"><col width="145"><col width="54"></colgroup><tbody>[TR]
[TD="class: xl64, width: 110"]Date:[/TD]
[TD="class: xl65, width: 180"]Name:
[/TD]
[TD="class: xl65, width: 145"]Location:
[/TD]
[TD="class: xl65, width: 54"]Total:
[/TD]
[/TR]
</tbody>[/TABLE]
Nov 21 Test 1 New York 5
Nov 22 Test 2 California 4
Nov 23 Test 3 New York 6
Nov 24 Test 4 Florida 3
Nov 25 Test 5 Texas 7
Nov 26 Test 6 New York 8

so since there are 3 instances of New York in the 'Location' column, I want to have it add up the 5, the 6, and the 8 so the cell with formula would display 19.

 

[JoeMo]

Have a look at the SUMIF function in Excel Help.

 

[wgregoryjr]

Worked great!!! Thank you!

 

[JoeMo]

Worked great!!! Thank you!

You are welcome - thanks for the reply.