calculate across sheets

  1. K

    Calculating results by combining two tables in MSaccess

    I want to draw a result based on data available in two different tables in the same database. Basically, I want to calculate the % share from both of these tables My Table 1 looks like this and has data somewhat like this. | Code | Category | |------|----------| | ABC | 123 | | BCD | 145 | | DEF...
  2. T

    Auto populate holiday tracker from year planner

    Hi, I have a sheet "Planner" where I can input the holidays taken by employees. All these sheets currently work fine as they are if I were to input data manually. What I am looking to do is auto populate sheet "Holiday Overview" cells C4:N28 with the hours holiday taken which is based on the...
    • ~TaC~
    • Thread
    • auto populate calculate across sheets holiday lookup and match tracker
    • Replies: 2
    • Forum: Excel Questions
  3. I

    Formula not calculating automatically

    Hi, =SUMPRODUCT((Sheet1!$B:$B='Sheet2'!$A2)*(Sheet1!$I:$AL='Sheet2'!C$1)) The formula above is forcing me to select the cell then press enter on each individual cell to calculate it. I've checked the formula calculation is on Automatic and the cells are formatted to general. Can anyone advise...
    • ian_noobster
    • Thread
    • calculate across sheets cell formula formula and functions sumproduct
    • Replies: 6
    • Forum: Excel Questions
  4. S

    Excel guidance - Matching Role and Employee competencies and bring back highest match

    Good afternoon, I have two main sheets that are outputs of a process. Sheet 1 has a list of critical roles and the behavioural competencies for that role and each role is rated depending on whether that competency is Critical to the Role, Highly Desirable, or not necessary. Sheet 2 has...
    • sjackson77
    • Thread
    • calculate across sheets macro - formula match 2 criteria summarize tabs into one
    • Replies: 5
    • Forum: Excel Questions
  5. B

    Calling a function

    I've got a code that searches a loads database, takes the numbers and puts them into a calculator, gets a number from the calculator and then adds that factored load to another database. To perform each of the major steps in my code, I call a function. Now when I call each function in order...
    • bsher
    • Thread
    • calculate across sheets call a macro large data large function
    • Replies: 2
    • Forum: Excel Questions
  6. T

    Calculations across multiple sheets

    Hello Everyone! I have quite a daunting task to perform. I have a spreadsheet with: 1.data divided into categories (by date, site, number, products); 2. within the cell are contained alpha/numeric; 3. I need to calculate that field (alpha/numeric); 4. the location of these items are on several...

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