This is probably simple

[enoch5939]

I need to "count" the total of a column with a given value...

Eg

In Column H, i have a dropped down box with Options. One of the options is "Re-Openned" ...

At the ended of the week i would like to be able to "count" how many times I have "re openned" something ...

I am sure this can be handled by an if statement.. i am just not sure how to go about it ...

Can someone help me out ???

 

[Oaktree]

Welcome to the board.

=COUNTIF(H:H,"Re-Opened")

 

[enoch5939]

thanks ...


and thanks .. I forgot about countif ... LOL ...