I am looking for a formula that will Count the month (A) for any "x" value in (L). And count that month within the year column (B).
So for example is (A) counts "1" as the value in 2017. But let's say there are 30 counts of "1" in (A). I just want in another cell the formula to return the "1" where the value equals "x" in column (I). Something where I can drag the formula down and hopefully it will look just return the first time a month is called out in (A) where there is an "x" in column (L).
similar to what the pivot is doing below which I want to get rid of.
It is counting months 1-12, but only returning a count with the cells that have values.
In the case of the pivot, the cells with values are sums on column (I) in this data tab.
I have this formula in there now, but it won't work in full like I need it to.
=COUNTIFS(I:I,"x",A:A,1,B:B,2017)
Bookmarks