Outdoorsman80
Board Regular
- Joined
- Oct 4, 2014
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
I have a spread sheet with several columns:
<tbody>
</tbody>
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.
Date Purchased | Item | Mint Year | Type | Metal | Oz |
<tbody>
</tbody>
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.