Panchistiko
New Member
- Joined
- Oct 22, 2009
- Messages
- 37
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.
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 |