tabs in formulas

  1. S

    Countifs Formula

    Hello, I'm looking to get the count of the number of times a month within a year is listed in 2 tabs in excel. Column BU tab in Gone is the Months in the formula Column BV tab in Gone is the Years in the formula Column P in ISRs tab is the Months in the formula Column Q in ISRs tab is the...
    • Sparda142
    • Thread
    • countifs formula ifs with calculations month and year tabs in formulas
    • Replies: 2
    • Forum: Excel Questions
  2. H

    Help Counting Outstanding Assignments

    I have a workbook to chart assignments given to 30 or so subcontractors. Each contractor has a tab within the book. The table in each tab the following column headers: Lease #, Date Ordered, Date Due, Date Received. I'd like an index page that shows a column with each of the contractors name...
  3. M

    Using name tabs in formulas

    I have a workbook where for each new month I am importing data into a new tab and then using SUMIFS to derive a total by data values. Each tab is named Jan 14, Feb 14 etc. I'd like to have a formula that will go to the right tab and select the data based on the month that is input to a cell...
  4. C

    Sumif - Multiple Sheets

    Hi all How can I sumif over multiple tabs?? Without using sumif(a:a,sheet1!a1,c:c)+sumif(a:a,sheet2!a1,c:c) Like sumif(sheet1:sheet2!a:a,a1,sheet1:sheet2!c:c) I do not want to use a macro. I have about 80 sheets. Sheet1 Apples 93 Pears 49 Oranges 20 Bananas 35 Sheet2 Apples...
  5. D

    Change formula to reference new tab in seperate file.

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

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