Hi Everyone, I’m currently working on a spreadsheet for my job. The goal of the current equation is to look at the criteria of the columns and give a total based on a certain month and Species of wood. (For example I want to find the total number of Pop + RO or Stock at 1 for the month of April.)

I have figured out how to find the total for April which was the formula “=SUMIFS(F2:F10834,C2:C10834, “>=” &J4,C2:C10834, “<=” &EOMONTH(J4,0))” but when I add another criteria Ex, “=SUM(SUMIFS(F2:F10834,I$2:I$1048576, 1,C2:C10834,”>=”&J4,C2:C10834,”<=”&EOMONTH(J4,0)))” the equation doesn’t work. What is going wrong where this fails. I also tried to use DSUM but couldn’t figure out how it works. What formula would be my best bet in figuring this out. The 1 and 0 (I column) which is what I’m trying to figure.

​Hi Everyone, I’m currently working on a spreadsheet for my job. The goal of the current equation is to look at the criteria of the columns and give a total based on a certain month and Species of wood. (For example I want to find the total number of Pop + RO or Stock at 1 for the month of April.) I have figured out how to find the total for April which was the formula “=SUMIFS(F2:F10834,C2:C10834, “>=” &J4,C2:C10834, “<=” &EOMONTH(J4,0))” but when I add another criteria Ex, “=SUM(SUMIFS(F2:F10834,I$2:I$1048576, 1,C2:C10834,”>=”&J4,C2:C10834,”<=”&EOMONTH(J4,0)))” the equation doesn’t work. What is going wrong where this fails. I also tried to use DSUM but couldn’t figure out how it works. What formula would be my best bet in figuring this out. The 1 and 0 (I column) which is what I’m trying to figure.   Read More

​