Calculate number of cells with two numbers

Hello!

Imagine this:

I have two rows.
Row A has number from 0 to 99
Row B has number from 0 to 30, so, for example:

(A) (B)
1 1
1 1
1 1
1 2
1 2
1 3
........
7 1
7 1
9 2
10 6


I then want to now: The number of Row B cells with the number 1 and with A=1, then the number of row b cells with the number 2 and A=1, then the number of rob b cells with the number 3, but with A=1. It would be: 3, 2, 4 ... and I want this to continue for a couple hundred (200) cells. For example then it would be ... The number of cells with B=1 and A=7 will be 2,

Thanks for all assistance.

The SUMPRODUCT() can be used to do a multi-criteria countif in the manner you're describing.

1) Assuming values in A and B through 300 rows
2) Assuming the A value you want to match is in C1 (1)
3) Assuming the B value you want to match is in D1 (1)
4) Put this formula in E1

=SUMPRODUCT(--($A$1:$A$300=C1), --($B$1:$B$300=D1))

Now put more rows of search data in C2 - D2, then C3 - D3 and copy that E1 cell downward to get more counts.

perhaps this

@ JBeaucaire: This is excellent, thanks.

@ martindwilson: Hi. For some reason I can not download anything but is it possible for you to explain? Thanks
EDIT: Thanks! I see it's kinda similiar to JBeaucaires.

A portion of Martin's workbook:

Please Login or Register  to view this content.

The formula in D3 and copied down and across is

=SUMPRODUCT(($B$2:$B$101=D$2)*($A$2:$A$101=$C3))

ok with your pairs of numbers starting in a2 and b2 downwards
from d2 to z2 put the numbers 0 to 23 that represents your possible b values
in c3 to d34 number down to 0 to 31 that represents your possible a values
in d3 put =SUMPRODUCT(($B$2:$B$101=D$2)*($A$2:$A$101=$C3)) drag across and down
youll now have a grid where you can read off the count if yoy have more that 100 rows increase range into match
note ive changed it from above to start both from 0 not 1.

This can be deleted, original post is what counts.

This can be deleted, original post is what counts.

i think you are probably over complicating things. are you saying col a will have 1 23 times then 2 23 times then 3 23 times all the way up to 31 23 times?? and b will be any number between 1 and 23? down to the end of col a ?
then with your rows starting a1 and b1 in c1 =SUMPRODUCT((B1:B1089=E1)*(A1:A1089=F1)) put value of b in e2 and value of a in f1 say 10 and 2 that will count all the times b=10 and f=2 if thats not right attach a work book

Working on it. Thank you all