Help with INDEX MATCH

[cesadine]

hi, im still new with some complicated formula, i need help with this table,
i want cell in B13 to B16 count coloum based on date in cell b11MPP ASK.xlsxScreenshot_110.png

[protonLeah]

Please Login or Register  to view this content.

[Gregb11]

Because the "1" in your grid are numbers, and the "1" in A13 is Text, my formula will not work as is. You either need to make your "1"s in the grid also text, or remove the tic mark in cell A13 and then "convert text to number". Then you could put this in B13 and copy down:

=LET(a,FILTER(FILTER($C$2:$L$9,$B$2:$B$9=$B$12),$C$1:$L$1=$B$11),IFERROR(ROWS(FILTER(a,a=A13)),0))

[cesadine]

Please Login or Register  to view this content.

im faliliar with your formula but you count all the coloum, i need only count row in area "surabaya"
what formula that need to be added

[AliGW]

YOu have marked the thread as SOLVED - is it?

[cesadine]

ahh sorry, i still try it when i marked solved, then realize i still have do something about my row

[cesadine]

YOu have marked the thread as SOLVED - is it?

ahh sorry, i still try it when i marked solved, then realize i still have do something about the rows
i still try protonLeah formula at the moment,

[windknife]

Try this in B12 and copy down.

Please Login or Register  to view this content.