Outdoorsman80
Board Regular
- Joined
- Oct 4, 2014
- Messages
- 62
- Office Version
- 365
- Platform
- Windows
I have a spread sheet with several columns:
[TABLE="width: 683"]
<tbody>[TR]
[TD="class: xl68, width: 122"]Date Purchased[/TD]
[TD="class: xl67, width: 266"]Item[/TD]
[TD="class: xl67, width: 98"]Mint Year[/TD]
[TD="class: xl67, width: 69"]Type[/TD]
[TD="class: xl67, width: 76"]Metal[/TD]
[TD="class: xl67, width: 52"]Oz[/TD]
[/TR]
</tbody>[/TABLE]
The entries have 3 different Types: Coin, Ingot and Round. I want a formula that will query the entire table and show me how many coins I have. How can I do this? I'm wanting to show the results on another sheet.
[TABLE="width: 683"]
<tbody>[TR]
[TD="class: xl68, width: 122"]Date Purchased[/TD]
[TD="class: xl67, width: 266"]Item[/TD]
[TD="class: xl67, width: 98"]Mint Year[/TD]
[TD="class: xl67, width: 69"]Type[/TD]
[TD="class: xl67, width: 76"]Metal[/TD]
[TD="class: xl67, width: 52"]Oz[/TD]
[/TR]
</tbody>[/TABLE]
The entries have 3 different Types: Coin, Ingot and Round. I want a formula that will query the entire table and show me how many coins I have. How can I do this? I'm wanting to show the results on another sheet.