Provider

Saturday, July 21, 2012

How to count text in colum on execl?

I want to count text “OFF” on the Colum on table below, take a look
 


1. You just write formula in other Colum , type =countif(select value that you want to count, “condition of text”)
 
2. You want to count “ON” on table above, Just type =countif(select value that you want to count, “condition of text”)
 

3. You want to count blank colum , type =countblank(select value that you want to count)

6 comments: