Counting matches from more columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a list something like this:

A B
P-no. Week
336 2
421 2
421 3
643 3
643 3
336 4
421 4
642 5

In separate colums I need to list how many lines with each P-no. I have in
each week, like this:

C D E F
Week 336 421 643
2 ? ? ?
3 ? ? ?
4 ? ? ?
5 ? ? ?

Hope someone can help with formular at questionmarks.
Thanks
 
Try this in D2:

=SUMPRODUCT(($B$2:$B$1000=$C2)*($A$2:$A$1000=D$1))

I have assumed you have 1000 items in your list - adjust if necessary.
Copy the formula across and down as required.

Hope this helps.

Pete
 
Back
Top