This post is about how you can count items in a portion of a column in excel dynamically. We will use countifs excel function combine with index function. For example Look at the Figure 1. We have different types of towers in column A and PI points in column B. Here we want to count…