sumifs range criteria

  1. R

    sumifs formula works in one column but only gives zero value in the next column

    Hello all, thank you for taking a look at this. I am using Excel for Mac 2011, OS X Yosemite. I am setting up a sales tracking database for my bakery. The data is entered daily, and I am building weekly and monthly summary sheets. Each product (e.g. Chocolate Chip Cookie) is a row. Each column...
  2. P

    SUMIFS with FILTER formula

    I'm looking to get a little guidance from someone who may know what I'm after. I've found nearly all my solutions from this forum for all my other projects but this particular issue seems to elude me. I'm looking to filter a list of expenses to a certain date range, then sum the expenses IF...
  3. M

    SUMIFS range criteria filters

    I have an Excel database query where I extract production runs (date run ended, volumes, product line, etc., which are then recorded in a worksheet called "EORData". In another worksheet, I have a week table where I summarize the data statistics:Table Column A: Production Date (formatted as...

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