Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
john_w100
 
Posts: n/a
Default 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
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

The solution would be dependent on the question.


  #3   Report Post  
duane
 
Posts: n/a
Default


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

  #4   Report Post  
Chip Pearson
 
Posts: n/a
Default

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



  #5   Report Post  
john_w100
 
Posts: n/a
Default


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



  #6   Report Post  
john_w100
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple question Sheila Clarke Excel Discussion (Misc queries) 2 March 24th 05 05:31 PM
Simple But Stumped Brian Keanie Excel Discussion (Misc queries) 3 February 5th 05 03:56 AM
Need a simple Secretaries Cash Book shaag Excel Discussion (Misc queries) 2 February 3rd 05 10:34 PM
A simple maco . . . Steve New Users to Excel 3 January 2nd 05 11:36 PM
Simple, Monday morning brain function craigwojo Excel Worksheet Functions 2 November 15th 04 02:43 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"