sumifs; arrays

  1. R

    Sumifs, index & match

    I am building a financial model that has one tab that has hard-coded data and another tab that is a formatted monthly financial statement. I am trying to formula that looks at the current month and the ID # and SUMS all of the data on the input tab that has that specific ID #. I know this is...
  2. M

    Sumifs Array not calculating all criteria

    Hi I am trying to use sumfis formula to calculate total sales using OR condition. I am using dynamic ranges in the formula but I have also tried using normal range as well. Formula is calculating only one random value in the criteria range and not all of them. Formula is here...
    • masood78
    • Thread
    • sumifs dyanmic range sumifs error sumifs with and/or sumifs; arrays
    • Replies: 1
    • Forum: Excel Questions
  3. J

    Rolling total

    What I am trying to do is keep track of billed and unbilled revenue from month to month by employee & contract. I have created a workbook with 12 worksheets (Jan-2013 through Dec-2013). In the January workbook, I am hard coding the December 2012 ending balances, but I can't figure out what...
  4. Wookiee

    Using A Cell As An Array Reference In SUMIFS Formula

    I have a report for which I would like to set up a Quarterly summary section. There are 6 working teams listed in my table and I have created two cells with data validation to allow me to specify which team and for which quarter I would like to pull data. My intent is to have a formula in one...

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