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...
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...
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...
<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...
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...
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...
=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...
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...
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...
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...
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...
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...
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...
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...
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 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.