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

The solution would be dependent on the question.

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=379621

What problem are you having?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"john_w100"
wrote in
message
...

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

Ok ive knocked up a small spreadsheet from the big one that im using but
cant attach it on this site, if someone emails me then i will email them
the sheet to try and solve my problem. Thanks again


--
john_w100
------------------------------------------------------------------------
john_w100's Profile: http://www.excelforum.com/member.php...o&userid=24368
View this thread: http://www.excelforum.com/showthread...hreadid=379621

Ive had a play about and have used the formula suggested earlier and
have got it working so thanks, it is very much appreciated :)


--
john_w100
------------------------------------------------------------------------
john_w100's Profile: http://www.excelforum.com/member.php...o&userid=24368
View this thread: http://www.excelforum.com/showthread...hreadid=379621