SUMIF Subtotals Pivot Table

[Panchistiko]

Hi, folks.

I have a Pivot Table ranging thousands of rows, just like the table below. I need to put in another cell the SUM of the subtotals greater than 20.
In the example blow, I need to sum 45+ 38. I tried SUMIF with the entire range, but it sums everything, not only the subtotals.

Any help? Thank you.

Server Failures.xlsx
	A	B
1	Servers	Count of Failures
2	SERVER1	45
3	Cause A	1
4	Cause B	44
5	SERVER2	38
6	Cause A	6
7	Cause C	32
8	SERVER3	19
9	Cause B	19
Sheet2

 

[Sufiyan97]

What formula you are using, can you post it here?

 

[Sufiyan97]

or
Try

Book3
	A	B	C
1	Servers	Count of Failures	Sum
2	SERVER1	45	83
3	Cause A	1
4	Cause B	44
5	SERVER2	38
6	Cause A	6
7	Cause C	32
8	SERVER3	19
9	Cause B	19
Sheet1

Cell Formulas
Range	Formula
C2	C2	=SUMIFS(B:B,A:A,"Server*",B:B,">=20")

 

[Panchistiko]

or
Try

Book3
	A	B	C
1	Servers	Count of Failures	Sum
2	SERVER1	45	83
3	Cause A	1
4	Cause B	44
5	SERVER2	38
6	Cause A	6
7	Cause C	32
8	SERVER3	19
9	Cause B	19
Sheet1

Cell Formulas
Range	Formula
C2	C2	=SUMIFS(B:B,A:A,"Server*",B:B,">=20")

Oh, I appreciate that. I shouldn't write similar names, as my real server names don't follow any convention.

 

[SpillerBD]

Filter the Pivot Table to the Desired Results to be Summed.

 

[Sufiyan97]

Oh, I appreciate that. I shouldn't write similar names, as my real server names don't follow any convention.

then post the actual data with real names how they look like.