Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting an entry in cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting an entry in cells
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 On Aug 7, 10:27*am, slavenp wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting an entry in cells
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" wrote: 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 On Aug 7, 10:27 am, slavenp wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting an entry in cells
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:D$100=""))+COUNTIF (D$1:D$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 On Aug 7, 12:30*pm, slavenp wrote: 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" wrote: 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 On Aug 7, 10:27 am, slavenp wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
4 cells but only one entry | Excel Discussion (Misc queries) | |||
Best way to format cells for entry... | New Users to Excel | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Counting Unique entry from Concatenated list | Excel Worksheet Functions | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions |