Counting an entry in cells

[slavenp]

Using Excel 2007

I would like to get a formula that will allow me to count entries in column
C, but if an entry is made in column D that would supersede what is in column
C.

When an entry is made into column H I would like the total for columns C or
D to reflect this i.e. total number counted should drop.

I have listed names at top of s/sheet and totals are to sit in H1, H2 etc.
Hope you can assist. Let me know if you require additional info.

Cheers,
Paul

 

[Pete_UK]

You seem to be confusing the terms. Do you want to COUNT the number of
entries or to SUM them? How does a column D entry supercede the entry
in column C? Please give a clearer explanation of what you want to
achieve.

Pete

 

[slavenp]

Sorry Pete, no very good with this Excel game.

What I would like is to count the names I enter into column C, this would
show how many jobs are against that person. If the job was passed to someone
else, a name would be entered into column D - so the job should count against
the new person.

Does this help?

I'm having problems in trying to reply, keep getting message up telling me
there is an error with the system!?!

Ta,
P

 

[Pete_UK]

I presume you have the list of names in G1, G2 etc, and want the
counts in H1, H2. Put this formula in H1:

=SUMPRODUCT((C$1:C$100=G1)*(D$1$100=""))+COUNTIF(D$1$100,G1)

Adjust the ranges to suit your data, then copy down for as many names
as you have in column G.

Hope this helps.

Pete