raisedwell
New Member
- Joined
- Mar 4, 2010
- Messages
- 22
I need a formula that will count and provide a total of how many total sets based on multiple cells.
SET = 1 Hat, 1 Shirt, 1 Belt, 1 Pants, 1 Pair of Socks and 1 Pair of Shoes.
In the following example, I need a formula for cell B8, that will provide how many sets. The correct result should = 1.
Thanks so much in advance.
SET = 1 Hat, 1 Shirt, 1 Belt, 1 Pants, 1 Pair of Socks and 1 Pair of Shoes.
In the following example, I need a formula for cell B8, that will provide how many sets. The correct result should = 1.
Thanks so much in advance.