indirect sum vlookup

  1. A

    Sumif using indirect function

    I have a series of tabs, all of which are named by week end date. I also have a totals tab. What I want to do is have the totals tab autosum all of the other tabs even when new tabs are added. All tabs are formatted the same, Is the best function to use here Sumif with indirect and if so how...
  2. L

    Vlookup, Indirect, Sum of Multiple Pages in excel... Can you do this?

    I have a payroll report that I extract from ADP. It doesn't extract on the exact same line everyday it depends on who is working. I have wrote the formula for looking up the day total and it works however the MTD total is what I can't figure out. It needs to sum every time it finds a title -...

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