db count if...

A

AND

hello,
I got this data:
Name AK COD data
pino 16 PD 1302
pino 21 PC 1402
pino 16 MI 1602
pino 16 MI 1602
pino 16 CHI 1602
pino 03 MI 1602
ciccio 12 MZ 1302
luise 04 MZ2 1302
luise 41 MZ2 1302

I wish count for the first time each number of "name", and then how many
value it has for each limitation selectioned.
I don't wanna use filter on becouse the data are thousands and I have to
count hundreds of "name".

So for example, If I wish count:
how many "PINO" WITH
AK=16 and
COD=MI

the result is:
TOT PINO(for example in H2)= 6
and
Pino(with AK=16 and COD=MI)=2
and
Pino(with AK=16 )=4
Please help me .
I don't know how I can solve this trouble.
thanks a lot for your help.
 

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

Using COUNT for text occurances in unusual worksheet? 4
Look up a text value then count records < a date 3
Counting a Change in Data in a Subtotal 4
Count if between date parameters 4
How do I count values w/ criteria located in more than one column 3
Counting rows that meet multiple criteria 5
Counting Data From A Query 1
Count Unique With one Condition & No ROUNDUP 7

Top