Subtracting a column in pivot able

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

R
  • Locked
  • Question Question
Sorting list order in Slicer
Replies
1
Views
927
Peter_SSs
Peter_SSs
K
  • Question Question
How to create pivot table that shows the delta between two other pivot tables?
Replies
2
Views
507
Kelvinator1
K
J
  • Question Question
How can I copy the grouping rules from one pivot table to another pivot table?
Replies
0
Views
298
jaza_tom
J
J
  • Solved
VBA/Macro: Adding Pivot table with connection string
Replies
1
Views
174
Jette3173
J
R
  • Solved
XLOOKUP/VLOOKUP based on Pivot Table Response
Replies
6
Views
419
rachel06
R

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top