sumif and condition

  1. B

    Index/Match Formulas for Dates and business days

    Hi, if it helps, i've uploaded my file to dropbox: Dropbox file I have a workbook with two sheets. one called "2020", which is the main sheet and the other called "Data", where i'm basically just aggregating data. the purpose of this file is to essentially keep track of my finances...
  2. M

    SumIfs Using Indirect based on 2 Criteria

    Hi! I have been struggling for 5 days trying to get this formula to work. Basically, I need it to search across a few worksheets which I have named "JON" and sum a corresponding cell if it meets two conditions. The formula returns a "Value" error...
  3. H

    Help with "SUMIF" function

    I've made myself a budgeting spreadsheet to keep track of my finances. Now I'm in the process of putting some functions/ formulas to make it easier to use but am having difficulty with SUMIF function. My budget spreadsheet consists of a calendar type budgeting system where each month has it's on...
  4. J

    SUM-IF Formula Issue: Results Not Displaying When Draggin Formula Across & Down

    I am using the following SUMIF formula in my spreadsheet: =SUMIF('2020 CBAT Schedule'!$J:$J,!$A2,'2020 CBAT Schedule'!AX:AX) When I attempt to drag the formula down it displays zeros instead of hours from the corresponding tabfrom which it should be sourcing the information from. The same...
  5. M

    Sum If, for duplicates?

    Morning, I have a list of monetary values that are associated to reference numbers. What formula can I use in order to sum up the monetary values of the reference numbers if they are the same reference numbers. For example Ref: #123 Value: £100 #123 £200 #124...
  6. N

    Add only if between dates

    I can't determine whether to use COUNTIF, COUNTIFS, SUMIF, or SUMIFS in this situation. I've tried all four and none do what I want so I'm seeking guidance here. I'm trying to total items in a column only if the date in the adjacent column is between two dates. Column K is DATE (every day of...
  7. Johnny Thunder

    VBA Help - Need to modify code to build a formula x amount of times

    Hello all, I am working on creating formulas for a summary sheet and found a link to code that build permuations and its on the right track but I am not saavy enough to modify it. Here is the explanation. I have 2 columns, Column G is a for Prior Period, Column I is for Current. There is...
  8. N

    Sum if distinct value with multiple criteria

    I've been racking my brain all day on this one and desperately need someone to swoop in and give me the answer. Data is set up as follows: <tbody> SSN $Dollars Date 123 $10 10/10/2018 123 $10 10/12/2018 456 10/14/2018 456 $20 10/16/2018 123 11/10/2018 789 $10 11/12/2018 1011...
  9. Z

    Sumif Index match match

    I currently have a set of data as follows: <tbody> Jan-18 Feb-18 Mar-18 Apr-18 Jun-18 Jul-18 A 1 2 3 4 5 6 B 7 8 9 10 11 12 C 13 14 15 16 17 18 D 19 20 21 22 23 24 </tbody> I have a dynamic lookup value for the date and want to be able to sum the values that are less than or equal...
  10. J

    Vlookup? Countif? Sumif? Counting Repeated information Question

    Hello everyone, I am currently working with a large amount of data from an output. I am trying to make a formula that only counts one instance of a repeated value. Basically, and I am trying to make a head count based upon name and rank and I am getting repeated information throwing my count...
  11. I

    SumIf, Index, Match Need help with formula

    I would like to calculate the total hours for M, T, W, Th, F, Sa, Su Can you please help with the formula? I was able to get the total hours for each employee but haven't been able to figure out how to break it down per day. I have the following table: <tbody> Employee Name Employee Number...
  12. E

    How to sumif formula plus criteria of column to omit certain cells.

    Hello All, I love this forum learned a lot from here. I am stuck on a problem and was wondering if anyone can help. I have a table with 2 criteria that i am using a sumifs formula. I've also created another " zero check" column in the table to read 0 if row needs to be omitted and ""false" if...
  13. J

    sum range of cells given certain criteria

    You probably read this title and thought "=sumif, dummy". However this dummy can't seem to get it to work nicely in this case. Would love some assistance. To the issue: First off, I know I could do this via VBA, but I would love to be able to accomplish it with simple formulas if possible. I...
  14. M

    Sumif / Sumproduct - Help :)

    Hi Everyone - I'm looking to create a sum formula to capture multiple criteria and I am open for suggestions. <tbody> Jan Feb Mar List: List: Car 1 1 2 Car Jan House 2 2 1 Airplane Mar Airplane 2 3 3 Boat Boat 5 5 3 Formula: XXXX </tbody>...
  15. D

    Sum Product or Sum IF for criteria in multiple columns

    I am hoping you can provide assistance. I have a worksheet with various account numbers spanning several hundred rows. Although the numbers here are in sequence the accounts could vary 10045, 20048, 81007. What I would like to have happen is to have excel total the sum of a column if the...
  16. S

    Sum Row with standard condition

    Hello guys, I need a help create a sum with 1 condition in multiple columns. Here's an example: <tbody> Quantity 1 Quantity 2 Quantity 3 Quantity 4 Item 1 -1 0 1 2 Item 2 0 -1 1 2 Item 3 -2 1 -1 2 Item 4 0 1 1 -2 </tbody> What i'm trying to do here, i want the sum to be separated...
  17. N

    Button to change formulas - Filter 3, 6 and 12 months next to This months orders column.

    Hi All, Probably the hardest thing I've had to do in excel and I need someone with a better skill set than I currently have please! I've put together a pretty big spreadsheet which draws data from ODBC links to a database. Part of the report shows how much has gone out over 12, 6, and 3...
  18. S

    SUMIF "next" MIN... How do you do without macros?

    I'll C&P a small amount of the data below, but this is what I am trying to do. In column A there is a number between 1.002 and 1.900 which are grouped together. Then in column B there is a 1 or a zero (completely binary). I want to Sum all the groups' B columns. So for example, I have 16...
  19. P

    Summing a column within dataset based on column header

    Hi My dataset is similar to below I would like to sum the values in column D, for example, based on a chosen date in cell E1. So if E1 = 22/10/2017 then E2 would = 7 Many thanks <tbody> A B C D 1 06/10/2017 29/10/2017 22/10/2017 2 BA 8 7 4 3 BA2 4 1 1 4 BA3 2 3 2 </tbody>
  20. P

    Totalsum as per month,year when status changes

    TOTALSUM AS PER MONTH & YEAR WHEN STATUS CHANGES TO CASH OR DEPOSIT =SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"Deposit","Cash"},B3:R3:B8:R8:B13:R13)) ====THIS IS MY FORMULA WORKING FOR ALL the cell total whenever the status is cash or deposit but I want to do this formula with one more criteria as...

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
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 "".
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