sumif multiple criteria

  1. L

    Using sumif between two columns with an additional criteria

    I have a table with 4 Columns. ID Name Start_Time Finish_Time VSL1 Name1 15:00 18:00 VSL1 Name1 12:00 16:00 VSL2 Name2 05:00 15:00 VSL2 Name2 12:00 15:00 What I want to do is to get the total worked time of every ID. For example, for VSL1 would...
  2. A

    Sum based on range of multiple criteria....

    There's got to be a better way! In the example below, I want to sum column C only if none of values in column D appear in column B: <colgroup><col><col span="3"></colgroup><tbody> B C D 2 aaa 1 bbb 3 bbb 1 eee 4 ccc 1 hhh 5 aaa 1 qqq 6 abc 1 7 ccc 1 8 qqq 1 9 bbb 1...
  3. R

    Multiple criteria list in SUMIFS formula

    I was wondering whether it is possible to incorporate multiple criteria in a SUMIFS formula. I have a form control dropdown box with various items in it that have been linked to a list of cells within the spreadsheet. So my dropdown box has, for example: Item 1, Item 2, Item 3, Item 4, All...
  4. D

    Compacting Multiple SUMIF formulas with multiple criteria

    I am using the following formula to pull specific data out of a table based on the criteria 1Due through 26Due. Is it possible to rewrite the formula into one master formula from which I can reference and add 1 to the #Due value...
  5. E

    Sumif with 2 conditions

    Good afternoon, I need to sum the values in row 22 with conditions in two other rows (5 and 6). I have this formula, but it does not work: =SUM(IF(E$5:CZ$5="1";IF(E$6:CZ$6="LCPE*";E$22:CZ$22;0);0)) Row 5 is 0 or 1 and the condition is 1. Row 6 is a combination of the text LCPE and a number...
  6. D

    SUMIF, 3 Criteria

    I need a formula that gives the following three criteria: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> If (c5:c28) is more than 0.004, THEN give sum. If (c5:c28) is more than 0, but less than 0.005, THEN input “T.” If (c5:c28) is less than 0.001, THEN...
  7. D

    Sumifs with Three Conditions

    I need to sumif a column of numbers only if it meets three criteria and export the answer into another excel file. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> First Excel File (the final format I need): A B C D 1 Date Begin Time End Time Total 2...
  8. C

    Summing two ranges but only including the positive numbers

    I have two ranges of numbers that I want to get certain numbers from. When they are summed, some come out as positive numbers, and some negative. I want to collect and sum all the positives together, and all of the negatives together. I know I can do this in multiple steps, but I want to see if...
  9. D

    SUM, only if two other columns have certain criteria

    I am fairly new to Excel, I need the sum of a dollar amount in column B, but only if the month in column E = 11, and only if the category in column D = "T". I basically want to know the sum of the "T" in the month of November. For example: 10/18/09 $134.00 CH T 10 10/18/09 $250.00 CH O 10...
  10. N

    SUMIF with 2 conditions, one of which is "contains"

    Hi, I'm having a big problem trying to get the following to work and wonder if anyone can help? I would like to sum the cells in the value column, where 2 conditions are met. 1) The Initials column contains "PP", and the Month column is 1. The answers I expect for each combination are shown...
  11. B

    sumif multiple criteria

    little help with something I thought would be simple: in A column I have names: A1 = "josh" A2 = "dani" A3 = "bobby" in B column I have numbers: B1 = 2 B2 = 4 B3 = 5 I want to sum the B values for "josh" and "dani" only. (B1 and B2) I tried this: =SUMIF(A1:A3, "josh, dani", B1:B3) and this...
  12. C

    SUMIF - need help getting formula straight

    I have a spreadsheet as follows: <TABLE style="WIDTH: 185pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=246><COLGROUP><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width=22><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 72pt...
  13. S

    Sumif and ignore negative numbers...

    I have tried a few options that I have found on the boards but I have not been successful... My existing formula is working but I have now realized that there is sometimes negative numbers in the S - X columns and I need to ignore them. My existing formula: =SUMIF('Sales Orders...
  14. L

    Countif

    Hi All, I am trying to count a column in excel, range of A2:A200 and need to count the number of cells that contain dates and not free text. Can only think of COUNTIF, but having major problems with this. Any help would be great. Lyle
  15. D

    trying to use a lookup type function in SUMIFS

    I am trying to use the SUMIFS function to extract summary information out of a file but would like one of the criteria to be if the value being examined exists in a data table column. The following formula works for summing all values in E3 which equal apple (plus the rest of the criteria):-...
  16. C

    Ranged countif and sumif criteria

    I'm trying to figure out how to find out how to make the countif and sum if functions work for a table that uses cash values. I want excel to count records in a column that are greater then X but less then Y. I have used the help function and it says to use this: =countif(E:E,">5"&"<=10") When I...

Some videos you may like

This Week's Hot Topics

Top