wgregoryjr
New Member
- Joined
- Nov 21, 2017
- Messages
- 2
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.
<colgroup><col width="110"><col width="180"><col width="145"><col width="54"></colgroup><tbody>
</tbody>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.
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.
Date: | Name: | Location: | Total: |
<colgroup><col width="110"><col width="180"><col width="145"><col width="54"></colgroup><tbody>
</tbody>
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.