A little help, prob simple to anyone else

  • Thread starter Thread starter john_w100
  • Start date Start date
J

john_w100

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 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
 
Ok ive knocked up a small spreadsheet from the big one that im using bu
cant attach it on this site, if someone emails me then i will email the
the sheet to try and solve my problem. Thanks agai
 
Ive had a play about and have used the formula suggested earlier an
have got it working so thanks, it is very much appreciated :
 
Back
Top