sumifs multiple columns

  1. J

    Sumifs displaying 0 for only certain months in the dataset

    I'm using the formula below trying to grab items and dollar amounts (not formatted, data came straight from a csv pull). Only the months June, September, August, and July are showing the sums. The remaining months are showing 0. I'm not sure what's causing this since it came directly from a...
  2. C

    Sumif Multiple Columns with Multiple Criteria

    I'm trying to replicate the table below. How can I sum the total orders for each week with duplicate date values as column headers? The data is dynamic and the column dates will change, so I was wondering if it's possible to sumif the table array using date and week as criteria? Table...
  3. 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...
  4. M

    Sumifs with too many criterias

    <tbody> A B C D E F G H I J K L M 1 1/1/16 (WEEK 1) 1/8/16 (WEEK 2) 1/15/16 (WEEK 3) 1/22/16 (WEEK 4) 2 PRODUCT AREA SALES PRODUCT AREA SALES PRODUCT AREA SALES PRODUCT AREA SALES 3 SALES PERSON 1 P1 NY 1200 P3 NJ 800 P3 PA 1100 P2 CT 800 4 SALES PERSON 2 P3 PA 800 P1 CT 1200 P4...
  5. B

    Sumifs matching 2 criteria

    I have data: D = Amount (currency) E = Check number OR "CASH" (text) F = Date (at this point two options are 12/10/2015 OR 1/14/2016 (special m/d/yyyy) The data is in rows 2 - 203 (row 1 is headings) I want to sum the total of the "cash" received on 1/14/2016. I typed this, but the answer is...
  6. G

    SUMIFS with multiple columns?

    I'm having trouble figuring this out. I feel like SUMPRODUCT may be the required formula. Here's the situation: The application is for income statements. Across the columns is the month-end dates (1/31, 2/28, 3/31) etc... The column preceding the dates is the line items (revenue, COGS, opex...

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