Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
|
Thread Tools |
07-06-07, 10:02 AM | #1 |
Member
Mega Poster
Join Date: Jul 2003
Location: In the shadows to the left
Posts: 7,700
|
Geek Help: Excel formula
Okies im trying to make a new speadsheet for work.
Contained in the spead sheet are 10 columns, 2 of which are Operatives name and Job completed. What im trying to do, is calculate how many jobs have and havent been completed for each Operative. Example Operative---Job Completed Dave--------- --Yes Mark----------- Yes Sue------------ No Rodney--------- No Rodney--------- No Sue ------------Yes The table i want to create Name--Job Completed--Job Not completed Dave --------1 ------------------0 Mark --------1------------------- 0 Sue ---------1 -------------------1 Rodney ------0 -------------------2 The spread sheet will be a live sheet, and the names, and yes/No will be in drop down boxes. I have been using =count(if(G3:G1000=Dave)*(K3:K1000=Yes) but this will not work and i cant work out why. Any help greatfully recieved. |
07-06-07, 10:04 AM | #2 |
Guest
Posts: n/a
|
Re: Geek Help: Excel formula
is it george best?
|
07-06-07, 10:09 AM | #3 |
Member
Mega Poster
Join Date: Jul 2003
Location: In the shadows to the left
Posts: 7,700
|
Re: Geek Help: Excel formula
Was he a mild mannered Janitor?
|
07-06-07, 10:19 AM | #4 |
Guest
Posts: n/a
|
Re: Geek Help: Excel formula
You have pm!
|
07-06-07, 10:19 AM | #5 |
Guest
Posts: n/a
|
Re: Geek Help: Excel formula
i think rodney ought to be given a written warning.
billy idols brother bone isnt he? |
07-06-07, 10:20 AM | #6 |
Guest
Posts: n/a
|
Re: Geek Help: Excel formula
I hate excel, though have to use it all day. I much prefer powerpoint, pretty but useless. There's a fable in there somewhere.
|
07-06-07, 10:21 AM | #7 |
Trinity
Mega Poster
Join Date: Jun 2006
Location: Guildford
Posts: 8,027
|
Re: Geek Help: Excel formula
|
07-06-07, 10:23 AM | #8 |
Guest
Posts: n/a
|
Re: Geek Help: Excel formula
Confused. First, why there's an 'if' in the formula?
Also, are the remaining columns listing the different jobs, with yes/nos in them? Otherwise I'm wondering how you could get Rodney with 2 uncomplete jobs if theres only a choice between complete and incomplete. |
07-06-07, 10:29 AM | #9 | |
Member
Mega Poster
Join Date: Jul 2003
Location: In the shadows to the left
Posts: 7,700
|
Re: Geek Help: Excel formula
Quote:
The last column on the sheet is Notes. The sheet is an ongoing sheet that at the end of the month, i will need to know if the work is complete or not, then theres a notes column after that. Anyhoo, Thor is on the case, Thanks Thor. |
|
07-06-07, 10:31 AM | #10 |
Guest
Posts: n/a
|
Re: Geek Help: Excel formula
i'd still get rid of rodney
|
Thread Tools | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fantasy Formula One anybody ? | fizzwheel | Idle Banter | 106 | 04-11-09 06:54 PM |
geek help | Bibio | Idle Banter | 9 | 16-05-09 01:22 AM |
Excel | Graciepants | Idle Banter | 15 | 31-03-09 10:52 PM |
I`m A Geek! | Speedy Claire | Idle Banter | 25 | 21-04-08 10:05 PM |
formula one | medwaysv | Idle Banter | 10 | 19-03-06 11:17 AM |