Calculate by categories

G

Guest

Hello,

If I have the following:

A1 Famille - Véronique 2
A2 Famille - Véronique 2
A3 Famille - Véronique 2
A4 Famille - Véronique 1
A5 Famille - Véronique 2
A6 Ami - Véronique 2
A7 Famille - Véronique 2
A8 Famille - Véronique 2
A9 Famille - Benoit 2
A10 Famille - Benoit 1
A11 Famille - Benoit 2
A12 Famille - Benoit 2
A13 Famille - Benoit 2
A14 Famille - Benoit 3
A15 Famille - Benoit 4
A16 Ami - Benoit & Véronique 1
A17 Ami - Benoit & Véronique 2
A18 Ami - Benoit & Véronique 5
A19 Ami - Benoit & Véronique 1
A20 Ami - Benoit 2
A21 Ami - Benoit 2
A22 Famille - Benoit 2
A23 Ami - Benoit & Véronique 2
A24 Famille - Benoit 2
A25 Ami - Véronique 2
A26 Ami - Véronique 2

Is there a way to calculate how many I have of each categories???

Thanks!!!
 
D

Debra Dalgleish

You could use a pivot table to summarize the data.
Add a heading to each column, then create a pivot table.
Put the Category fields in the Row area, and the Count column in
the Data area, where it will total the amounts.

There are pivot table instructions and links here:

http://www.contextures.com/xlPivot01.html
 

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

Data Compare 1
MOD Function: MOD(7.0,1) = 1 Why? and how to work around it. 13
how to use an formula to transpose a list(left) to be like the right? 2
sum if 1
Copy down (propagate) function/forumula needed 4
How do you repeat a function in a formula 4
Problem with size limit of function's argument declared in VBA 1
Excel Macro Help 4

Top