|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 16th, 2005, 02:13 PM
|
|||
|
|||
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
June 16th, 2005, 04:28 PM
|
|||
|
|||
|
The solution would be dependent on the question.
|
|
#3
June 16th, 2005, 04:33 PM
|
|||
|
|||
|
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
June 16th, 2005, 07:23 PM
|
|||
|
|||
|
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
June 17th, 2005, 10:05 AM
|
|||
|
|||
|
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
June 17th, 2005, 01:47 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook bug: views do not work after simple find. | N. P. | General Discussion | 1 | March 11th, 2005 05:59 PM |
| Simple, but needed | Ben | Using Forms | 7 | November 1st, 2004 12:07 PM |
| simple columns won't add | Phil | Worksheet Functions | 3 | October 5th, 2004 11:04 PM |
| How to Do Simple Vector Based Graphics Using MS-Access? | Jay Chan | General Discussion | 2 | September 1st, 2004 04:29 PM |
| Simple inventory System | Alexthecamel | New Users | 3 | September 1st, 2004 01:49 PM |
Linear Mode
