Counting the number of entries in a column

  • Thread starter Thread starter Wombat
  • Start date Start date
W

Wombat

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
 
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
 
I dont have the product name in column B. Just the number of products ordered
(usually more than one)
 
Ok, so what do you want to count, could you give me an example of your data,
thanks
 
Right:

column A contains numbers 30 to 40 representing which area the customer is in.
Column B contains the number of articles ordered by this customer. eg 5

I want to be able to count how many customers from each area has placed an
order eg. how many cells have something in them in column B WHEN column A
contains the correct area number

I basically need a formula which would work in a similar fashion to a SUMIF
but without it adding the numbers... just counting how many cells have
something in them
 
Make a list of your areas in column E starting in E1 and in F1 enter

=SUMPRODUCT(($A$1:$A$3=E1)*($B$1:$B$3<>""))

change range to fit your needs and copy formula down, remember range has to
be the same in both sides of the formula
 
It works! Thanks for the help :-)

Eduardo said:
Make a list of your areas in column E starting in E1 and in F1 enter

=SUMPRODUCT(($A$1:$A$3=E1)*($B$1:$B$3<>""))

change range to fit your needs and copy formula down, remember range has to
be the same in both sides of the formula
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting the number of different entries in a column 2
Count number of days from the last entry? 2
formula to count text entries and return text with most entries 8
Counting an entry in cells 3
n=? in each column 4
select a range in a column 4
Get the row count of different areas in the Excel 2
counting entries 2

Back
Top