formulas from columns

  1. S

    using formulas to sum on various pivot table columns using criteria from other tabs and tables

    Hello, I have the following formula on one tab of my workbook which presents a client directed view of costs and hours for groups of resources which are described in a pivot table on another tab. =GETPIVOTDATA("Sum of Tot.Pro.Hrs",'Resource Costs by...
    • Sfraizingr
    • Thread
    • dynamic cell reference formulas formulas from columns multipe sheets pivot table
    • Replies: 1
    • Forum: Excel Questions
  2. M

    Help with formula to automatically pull information from one tab into another

    I receive a detailed sales report each week and I'm asked to create tabs in the workbook for specific calculations based on the data (total sales, delivery times, quantity sold, etc...). The sales reports as a whole aren't always structured the same but the columns I use for my calculations...

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