How do I use Counta in a pivot table

[ajt8888]

How do I use Counta to count the number of cells in a pivot table where the number is greater than 0

 

[Kerryx]

i would normally use countif

1- Inspection Plan Log.xlsx
	A	B	C
3	Row Labels	Sum of Stk
4	Oil 1	0	4
5	Oil 2	1
6	Oil 3	0
7	Oil 4	2
8	Oil 5	14
9	Oil 6	0
10	Oil 7	5
11	Oil 8	0
12	Grand Total	22
Sheet2

Cell Formulas
Range	Formula
C4	C4	=COUNTIF(B4:B11,">0")

 

[ajt8888]

i would normally use countif

1- Inspection Plan Log.xlsx
	A	B	C
3	Row Labels	Sum of Stk
4	Oil 1	0	4
5	Oil 2	1
6	Oil 3	0
7	Oil 4	2
8	Oil 5	14
9	Oil 6	0
10	Oil 7	5
11	Oil 8	0
12	Grand Total	22
Sheet2

Cell Formulas
Range	Formula
C4	C4	=COUNTIF(B4:B11,">0")

Thanks but that means I have to change the formula every time I change the filter

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Use of Counta Formula in a pivot table

I want to count the non blank cells in pivot table columns and have been using counta but this means I have to change the formula each time I change the filters. I have read that it is possible to use Counta in a Pivot table but despite a number of goes I have to accept defeat as its beyond me...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Kerryx]

Due to the limited amount of information i am working in the blind here, your original request mentioned nothing of filters. You could make the range implicit using for example

=COUNTIF($B$4:$B$11,">0")

or just leave the $ out of the formula and put in max range to count

 

[ddutton]

Due to the limited amount of information i am working in the blind here, your original request mentioned nothing of filters. You could make the range implicit using for example

=COUNTIF($B$4:$B$11,">0")

or just leave the $ out of the formula and put in max range to count

but what if the column needs to be measured by two values. A greater than and a less than value?

 

[Joe4]

but what if the column needs to be measured by two values. A greater than and a less than value?

Then use COUNTIFS, which allows for multiple criteria.
See: COUNTIFS function - Microsoft Support