sum accross sheets

  1. C

    sumif across multiple sheets

    I have sheets named Jun 2012, Jul 2012...to Mar 2015 I want to sum (across all sheets) s:s if r:r =q2 I have seen this formula =SUMPRODUCT(SUMIF(INDIRECT("'"&Z1:Z212&"'!B3"),99,INDIRECT("'"&Z1:Z212&"'!G3"))) But cant seem to tailor it to my needs I have a list on the sheets running from...
  2. C

    SUM IF between two dates and another criterion

    Hey, So I'm trying to pull combined sales data of an item between certain dates. The sheet I'm pulling from has the data by day so I'd need it combined for the specific dates queried using the item number. Currently I was trying =SUMIFS(MIS!G:G,MIS!D:D,">="&DATE('PV...
  3. V

    Sum Across Different Sheet/ Simplifying a Formula

    Does anyone know how to simplify this formula? I am going to have more sheets that will have text names - not just sheet 1, sheet 2, sheet 3, etc. Ideally, it would be great if I could reference the entire group of sheet names and then be able to add more names to the group as I create more...
  4. D

    SumFormula used for multiple cells in macro

    <tbody data-remaining-comments-count="0" data-canpost="true" data-cansee="false" data-comments-unavailable="false" data-addlink-disabled="false"> <tbody> </tbody> I have a series of check boxes on a sheet called "Resource Estimator." The user clicks the boxes that apply and based off the...
  5. A

    Sum Across Multiple Sheets with Look Up Function

    Hi there, I am new to this forum, and I am looking for help to create a formula that sums values in the same column across three sheets on a summary tab (sheet four). However, each sheet has a different number of rows, but each row has a unique identification code. Is there a way to sum the...
  6. K

    Calculate discount based on dates variable in PowerPivot

    Hi! I have two tables in my PowerPivot (see example below). The first one (Table A) shows different packages at different hotels and how much they cost. The second table (Table B) shows how much discount we can get from the different hotels. The discount is based on when the guest are staying...
  7. R

    Need to Expand Current Formula

    =IF([TimeSheets.xlsx]Tim!B12="_r2500",(SUM('[TimeSheets.xlsx]1st:Last'!$E$23)),"0.0") This works as expected; however, I need to expand the "Tim" worksheet to include 1st:Last. (When I attempt this, I receive a #REF error.) I don't understand why 1st:Last works in the SUM, but not in the IF...
  8. M

    Certain criteria If function

    So if I have three adjacent cells: 0 3 0 I want to keep this data. But I also want to sum these three numbers up. The issue is that the "3" is equal to a "N/A", so I dont want to include it in the sum. How can I add these three cells up without including the 3? Note that the placement...
  9. J

    Matching, sum and return a value

    Hello! I have just started a new job and trying to get a handle on some new data and techniques, and I could use some help! I need to be able to match a project number in one excel sheet, to another, and return a sum of 2 cells relating to the project number to the original sheet. Basically...
  10. F

    Selected Sum

    Hi, I have simple table: <tbody> A1: Country B1: Value A2: Poland 10 A3: USA 5 A4: Germany 2 A5: Poland 5 A6: UK 3 A7: Germany 3 A8: Poland 2 A9: Total =Sum(B2:B8) = 30 </tbody> Now when I'm using filter and select Country = Poland, the total should be: 10+5+2=9. But always...
  11. H

    Dynamic sheet access and reuqired sum of all the sheets in summary

    Hi Team,</SPAN> I’m looking for below requirement can anyone help me on this… </SPAN> I have macro which generates the various sheets (dynamic) it depends on master data volume and sometime 3 sheets or some other times it may go upto 10 sheets… In summary sheet I need to take column K:K total in...
  12. D

    Adding from different worksheets

    My first worksheet is labeled Spirs 1 and the folowing sheets are labeled A CO, B CO, C CO, D CO, and HHC, all in the same workbook. I want to add the data from B2 on the worksheets and display the results in Spirs 1, B2. I have done all I know and every time I think I have it right it opens up...
  13. E

    Sum values until the active sheet

    Hello all, This is my first post here. I've searched the entire forum but couldn't find an answer for my situation. This is what I am trying to do; My sheet names are the dates of the month.. 07 Feb,08 Feb,09 Feb etc.. I want to sum up the values in a cell(for example L41) in every sheet from...
  14. M

    SUMIFS formula help

    I'm working on a balance sheet. It basically works around one main transaction table where I classify each transaction according to its value, the currency in which it was paid, the month in which it happened and the type of transaction. The following is a formula for a table that is derived...
  15. O

    How to use VBA userform to sum accross worksheets.

    I have workbook that has a tab for each week in a month. I have used a VBA userform with a multiselect listbox to allow the user to select multiple worksheets to roll-up into a summary worksheet. My problem is writting the sum formula to accept the listbox's array. Here is my code. I have used...

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