Counting the number of entries in a column
Hi,
I assume your product is in column B and the product name is XX
=countif(B1:B100,"XX")
Change range and product name to fit your needs
you can have as well the product you want to count entered in a cell let's
say C1 in that case you can replace the above formula with
=countif(B1:B100,C1)
if this helps please click yes thanks
"Wombat" wrote:
Hi!
I have area numbers in column A and the number of produkts ordered in column B
I want to count the number of entries in a particular area bearing in mind I
just want to see the number of entries rather than sum them up like SUMIF. Is
there a convenient formula which would allow me to do this?
Thanks for any help
|