cloumnwise rowcount excluding null values

See more:

SQL-Server

Hi friends,
Please help me..
i want columnwise rowcount(excluding null values) in single query..
see the below example:
table1:

------------------------------
col1  |   col2      |   col3
------------------------------
 1    |  null       |   test
 2    |  1w         |   test1
 null |  null       |   test3 

------------------------------

output will be:

----------------------
columnname | count
-----------------
col1       | 2
col2       | 1
col3       | 3
------------------

for above output i have tried below sql query:-

select a.name ,(select count(a.name) from users b where a.name is not null)
from syscolumns a where id=(select id from sysobjects where name='users')
group by a.name

but it is giving me all tables rowcount like-

col1 |3
col2 |3
col3 |3

:(


Thanks in advance...