Frncis
Member
I have a spread sheet that breaks down data by month. I.e. column I is the month, & Column j is the size. So, cell I7 has (10), & cell J7 has a quantity (5). The header for column I7 is Month, J7 is 6M. I8 may have 10 as the month, but the quantity in J8 is 15.
I have another area on the same sheet tracks all the sizes for the month of October. Cell AI7 has this formula =COUNTIFS(J7,"1",I7,10). It is a formula that I have used for another application, & I am trying to modify. The expected answer should be 5, but I can’t figure out the correct formula. I have googled, but have not been successful. I guess, my question is how do I replace "1" with something that accepts a variable answer.
I have another area on the same sheet tracks all the sizes for the month of October. Cell AI7 has this formula =COUNTIFS(J7,"1",I7,10). It is a formula that I have used for another application, & I am trying to modify. The expected answer should be 5, but I can’t figure out the correct formula. I have googled, but have not been successful. I guess, my question is how do I replace "1" with something that accepts a variable answer.