Geek Help: Excel formula

[Viney]

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.

is it george best?

[Viney]

Was he a mild mannered Janitor?

You have pm!

i think rodney ought to be given a written warning.

billy idols brother bone isnt he?

I hate excel, though have to use it all day. I much prefer powerpoint, pretty but useless. There's a fable in there somewhere.

[Stu]

Originally Posted by thor

You have pm!

Is this answered now or not? why so secretive?

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.

[Viney]

Originally Posted by Flamin_Squirrel

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.

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.

i'd still get rid of rodney