sumif multiple lists

  1. G

    Sum sumif of values of matches with multiple columns

    My formula works. However, I would like to: 1. If possible, simplify this formula (By not using "+"). 2. Prevent errors if there are blanks in Columns DP or DV. D9 is a formula-driven value (Name) that will appear as a multiple occurrence in Columns DO114:DO469 and in DU114:DU469. The numeric...
  2. S

    The "Burger" question

    Hi All. It is the end of Friday and my Brain just mushy. :banghead: Here is what I am trying to figure out. Background: At work we have machines that are using raw materials. Some of them only uses 1, others 2,3, 4 blend of raw materials. Each machine uses different amount from each material...
  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. C

    Sumif - Multiple Sheets

    Hi all How can I sumif over multiple tabs?? Without using sumif(a:a,sheet1!a1,c:c)+sumif(a:a,sheet2!a1,c:c) Like sumif(sheet1:sheet2!a:a,a1,sheet1:sheet2!c:c) I do not want to use a macro. I have about 80 sheets. Sheet1 Apples 93 Pears 49 Oranges 20 Bananas 35 Sheet2 Apples...
  5. J

    SumIF with multiple lists

    Hi all, I've been looking around but cant find an answer to this (seemingly) simple question. (Apologies if the text doesnt layout correctly) Say I have a 2-column list of values - text and its assigned number: text1 100 text2 200 text3 500 text4 1000 ... text8 200 text9 50...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top