A little help, prob simple to anyone else

Hi i am a very novice excel user and am wondering if anyone can help me with the problem below ?.

Example sheet
A B C
.......Weld number.....Welded by..... Approved
1............1......................2....................Y
2............2......................1....................N
3............3......................1....................Y
4............4......................2....................Y
5............5......................3....................N
.
. .
I want a row which when i input a welder number gives me the total number of welds he has completed and also the number approved and the number been rejected, as i have nearly 20,000 welds i dont want to search and complete this by hand. See below

Welder number.......Number welded........No. Approved......No. Rejected
...........2..............................2........................... 2..........................0
...........1..............................2............................1..........................1

Any help would be much appreciated

I will assume your data is in cells a1:c10000 (row 1 being the headers)

and your summary table is in e1:h4

e2 = welder # - say 1 for example

count of welds by this welder

f2 =sumproduct(($b$1:$b$10000=e1)*1)

count of approved welds by this welder

g2 =sumproduct(($b$1:$b$10000=e1)*($c$1:$c$10000="Y"))

count of rejected welds by this welder

h2 =f2-g2

copy down thru row 4 or as needed