Tally lists based on results

[Guest]

I need to calculate how many alike products are chosen in a table from data
tables (validated data) to show a tally. How on earth do you do this?

How do i calculate how many "Blue" items are listed each time a Blue item is
added to the list etc? Each time a new item is listed, it will automatically
appear in the tally list as a new item and/or count tally. There is a
possibilty of 1000 items though commonly only a maximum of 10 should appear
in the tally.
eg. The data collected by input.
A B
1 Blue $50
2 Red $40
3 Blue $50
4 Orange $20
5 Blue $50
6 Orange $20
etc

In this example, there are:
3x Blue, 1x Red, 2x Orange.

I require the tally list to look like this alphabeticalised by name:
eg. The tally list.
A B... K L
10 Blue 3
11 Orange 2
12 Red 1

Your help in programming will be greatly appreciated.
Thank you.

 

[Bernard Liengme]

=COUNTIF(A:A,"Blue")

 

[Don Guillett]

Have a look in the help index for SUMIF

 

[Guest]

Sorry, been away.

This doesn't seem to work.
I used both functions listed in this topic and it didn't work.

hmmm, I have 2 sheets, one sheet is the actual "datatable" (or vlookup) of
the products and price that are used with defined names.

Another sheet has the sales made that day where you select from a dropdown
box using "validated data". The v/data under the products sold i want to sum
up, how many were sold that day but in a different table next to the sales.

I have created a space next to the table where i want to list the top 10
products sold ranked from the most sold to the least sold from the v/data,
price not required.

When i use SUMIF or COUNTIF as in Excel help with say "blue" as below
exampled, no results (0) returned from the range of data
[=COUNTIF(D591,"Blue")].

Is this because of v/data or I'm just doin' it wrong?
Mind you, the datasheet contains 900 product lines. Surely I do not need to
enter ... "Blue" "Orange"... into the formula?

Help.

 

[KC Rippstein]

If your summary table is in K2:L11 like you show below, then L2
=SUMIF(A:A,K2,B:B) and copy down to L11.
This will be sorted alphabetically, not by sales volume. That will require
a sort when you are done updating.

Sorry, been away.

This doesn't seem to work.
I used both functions listed in this topic and it didn't work.

hmmm, I have 2 sheets, one sheet is the actual "datatable" (or vlookup) of
the products and price that are used with defined names.

Another sheet has the sales made that day where you select from a dropdown
box using "validated data". The v/data under the products sold i want to
sum
up, how many were sold that day but in a different table next to the
sales.

I have created a space next to the table where i want to list the top 10
products sold ranked from the most sold to the least sold from the v/data,
price not required.

When i use SUMIF or COUNTIF as in Excel help with say "blue" as below
exampled, no results (0) returned from the range of data
[=COUNTIF(D591,"Blue")].

Is this because of v/data or I'm just doin' it wrong?
Mind you, the datasheet contains 900 product lines. Surely I do not need
to
enter ... "Blue" "Orange"... into the formula?

Help.

Have a look in the help index for SUMIF