Count cells from a dynamic row - Microsoft Community
This formula will automatically search for the matching value of G2 in column A and get the row number where the match is found. It then uses the row number to find the corresponding project range and finally uses the COUNTIF function to count the occurrences of the value in H1. I hope the formula works for you, and I look forward to your reply!
more
|