# SUMIF Subtotals Pivot Table

#### Panchistiko

##### New Member
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
AB
1ServersCount of Failures
2SERVER145
3Cause A1
4Cause B44
5SERVER238
6Cause A6
7Cause C32
8SERVER319
9Cause B19
Sheet2

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
What formula you are using, can you post it here?

or
Try

Book3
ABC
1ServersCount of FailuresSum
2SERVER14583
3Cause A1
4Cause B44
5SERVER238
6Cause A6
7Cause C32
8SERVER319
9Cause B19
Sheet1
Cell Formulas
RangeFormula
C2C2=SUMIFS(B:B,A:A,"Server*",B:B,">=20")

or
Try

Book3
ABC
1ServersCount of FailuresSum
2SERVER14583
3Cause A1
4Cause B44
5SERVER238
6Cause A6
7Cause C32
8SERVER319
9Cause B19
Sheet1
Cell Formulas
RangeFormula
C2C2=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.

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

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.

Replies
0
Views
667
Replies
1
Views
534
Replies
4
Views
87
Replies
3
Views
220
Replies
1
Views
112

1,203,065
Messages
6,053,325
Members
444,653
Latest member
Curdood

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back