We can do this easily with the COUNTIF formula!
THE COUNTIF Formula
The formula itself is not too difficult.
The first part of the formula wants you to input (drag) a range where we going to look for stuff to count.
Then the second part of the formula asks for the criteria (what to count)
Note, that we locked the formula in the example. This means that we can add or remove columns, this will not affect our formula.
Come and visit us.
Come and visit excelangel on Facebook to find and join the growing community of true office workers.
Oh, I almost forgot.
Drop us a like while you there…