#sumproduct

  1. M

    combining 2 formulas for sub ifs

    I found 2 very helpful formulas that work separately but I'm looking to find a way to combine them. I want to calculate the subtotal of D2:D101 only if the number is greater than 0 (so no negative amounts) and if the transaction type is "SALE" for G2:G101...
  2. L

    SUMIF/SUMIFS with multiple criteria

    Hi, Im stuck with a formula can anyone help? I want to sum the bottom row in the image below when two criteria is met, which is 'A' and 'Qty' The problem is the sum range needs to be the bottom row only(figures). The criteria 1 (A,B,C) is a merged cell if that makes any difference! Any ideas...
  3. T

    Sumproduct dates

    Hi All, I work for a non profit organization and helping them setup a budget workbook and getting totals for . Any help would be appreciated. I'm trying to sum of the totals based on dates that have a criteria which is the Employee ID. My goal is to get a formula for the total of Employee #20012...
  4. U

    Individual SumProduct Formulas work but when I combine I get the #Value! Error

    Hi Everyone, I have two sumproduct formulas that work on their own, but if I want to combine them both to get the total count for when both criteria are present, excel gives me the #value ! error. The formulas are: No1. Gives me correct result nr_FirstDate is a range of dates (not all cells...
  5. C

    Production

    In colume C & D I use the following formula to look into =INDIRECT(ADDRESS(SUMPRODUCT(($U$2:$AX$932=B5)*ROW($U$2:$AX$932)),(SUMPRODUCT(($U$2:$AX$932=B5)*COLUMN($U$2:$AX$932)))+1))...
  6. M

    Selecting specific text and suming the results.

    Dear All, Thanks in advance for your time to help me with my inquiry. I have some expenses data where I want to select common or close text from a list and sum the amount spent for a specific month "Mar". Then I will work on creating a dashboard out of it. Example of output required...

Watch MrExcel Video

This Week's Hot Topics

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
Top