COUNTIF -count number of items pertaining to a % and where value not zero

[howard]

I have a sheet containing Percentages in Col C and values in Col B


I want to set to a table on a separate sheet using a countifs formula to contain the number of items for ach percentage where the value in Col B is not zero


I am able to set up the formula to count the number of items for each % , but not where the value <> 0


it would be appreciated if someone could kindly assist me

Book1
	A	B	C
1	Reference	Value	Sales %
2	661956	25895	14.00%
3	60845YTr	6585	25.00%
4	608465R	98547	15.00%
5	REVERSE 608465	1475	12.00%
6	REVERSE 608465	11258	12.00%
7	60846	0	0.00%
8	60845	0	0.00%
9	1115	0	0.00%
10	108925	0	0.00%
11	48254	16.81	14.00%
Sheet1

 

[Joe4]

I am able to set up the formula to count the number of items for each % , but not where the value <> 0

The condition/criteria for that should just be "<>0"
If you are having issues incorporating it into your formula, please post the current formula you say that you have and is working for the %.

 

[howard]

Thanks for your input-I have now got it to work

 

[Joe4]

You are welcome.