This is probably simple

enoch5939

New Member
Joined
Oct 2, 2006
Messages
17
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 ???
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,113,993
Messages
5,545,378
Members
410,679
Latest member
rolandbianco
Top