Have a look in the help index for COUNTIF and SUMIF
--
Don Guillett
SalesAid Software

"???????" wrote in message
...
I used a match() function to find out a specified data in a range, and it
replied a number. Let's say I got 3(column or row). Is there any way to
know
how many data in the column 3(or row 3) by using counta() or any other
function, except VBA.
Thanks for any help