Search code examples
excelexcel-formulasumifs

Multiple SUMIFS

here is my formula I am currently working on: =SUMIFS(Leuf!G2:G1705, Leuf!D2:D1705, "January", Leuf!J2:J1705)

here is the sample data: [1]: https://i.sstatic.net/NWEXd.png

I am trying to calculate the total gallons based on the month in column F and also the column D as there are two different options "Clear Led" and "Dyed." I need to separate the cost but my current formula will not work.

Solution

  • Try This -

    =Sumifs("Sum Range", Criteria Range 1, Criteria, Criteria Range 2, Criteria)

    In your case formula should be

    =sumifs(j:j,G:G,"January",D:D,"Clear LED")