getting the sum of letters

[andrewb90]

Hi all! I'm sure this is fairly simple but, how do I add up the total number of times column D has a value of 'B'? The only other thing that may complicate this is some rows column D is merged with other cells so I want that excluded, and I only want to count the cells that are currently visible. Any hidden cells need not be counted.

Thanks,

Andrew

 

[T. Valko]

Awesome! Thanks so much!

You're welcome!