Sachin2k6
Active Member
- Joined
- Mar 3, 2012
- Messages
- 369
Hi All
I have a filtered range like this :
RowNo. ColumnA ColumnB
1 Gold 35
3 Silver 25
8 Silver 28
10 Gold 45
Range can be extended up to 10000 rows. I want the subtotal of the visible cells of the column B when the corresponding cell in columnA contains 'Gold'. How can i get this??
Thanks in advance.
I have a filtered range like this :
RowNo. ColumnA ColumnB
1 Gold 35
3 Silver 25
8 Silver 28
10 Gold 45
Range can be extended up to 10000 rows. I want the subtotal of the visible cells of the column B when the corresponding cell in columnA contains 'Gold'. How can i get this??
Thanks in advance.