sumifs()

  1. P

    Please help – optimizing heavy workbook containing volatile functions

    Dear all, I have a workbook that recently became heavy and unstable. The simplest of data entries and calculations are now extremely slow and laggy. Furthermore, this is a workbook that will need to be constantly updated with more data. I’m looking for suggestions on how to optimize what I...
  2. B

    Or Function in Sumif function

    Dear Friends, I tried following formula to sum whereever vetical is like "AMS" or "Pre" or "MNP" or "AVCV" =SUMIFS($C$6:$C$15,$B$6:$B$15,OR({"AMS","PRE","AVCV","MNP"})), but it is i am working only for first case. In this case I got sumation for "AMS" . Time being I have managed by altering...
  3. xd9813

    Open, SUMIFS, Close, Rename >5k workbooks (~3GB of data)

    Objective: Provide aggregate sales totals based on multiple criteria in Product Description column from >5K workbooks located within different folders & with different layouts, sheet names, and workbook names. However, all column names are similar (not 100% but close). The names of the...
  4. R

    Summary for Date & Instructor Across several sheets in one workbook

    Hello everyone, Below is the worksheet I'm wanting to summarize information from. I'm wanting to summarize HOURS for each DATE and for each INSTRUCTOR across all (33) worksheets, named Week 1 to Week 33. Below is the summary sheet I have created. I'm wanting to extract info from the...
  5. A

    Multiple criteria for Sumifs() & countifs() in Excel 2007

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> Hi,<o:p></o:p> <o:p> </o:p> I am trying to consolidate a report in which I need to get the sum & count for couple of rows.<o:p></o:p> <o:p> </o:p> Col A = Country Code<o:p></o:p> Col B = Table<o:p></o:p> Col...

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