|2 questions regarding SUMIFS:|
1. I have a SUMIFS formula giving me results based on 2 criteria but when I apply a filter for any number of reasons (sales person, month of sale, etc...) I still get the total of all cells rather than just the visible ones, can someone help me out?
range = Pipeline!$F$6:$F$794
criteria 1 range and cell = Pipeline!$AB$6:$AB$794,A3 - this is my branch
criteria 2 range and cell = Pipeline!$I$6:$I$794,MONTH(K1) - this is a cell that has a month(J1) formula to give me the month I am looking for for the month of the sale date I want
Here is my current formula:
2. When I add the month(k1) formula at the end I get a zero; I want the sum of that month