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.

Re: Geek Help: Excel formula
 

is it george best?

Re: Geek Help: Excel formula
 

Was he a mild mannered Janitor?

Re: Geek Help: Excel formula
 

You have pm!

Re: Geek Help: Excel formula
 

i think rodney ought to be given a written warning.

billy idols brother bone isnt he?

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.

Re: Geek Help: Excel formula
 

Is this answered now or not? why so secretive?

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.

Re: Geek Help: Excel formula
 

Its the formula that the Excel help says woudl give me the answer, but its not!

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. :)

Re: Geek Help: Excel formula
 

i'd still get rid of rodney