If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting an entry to a cell
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
|
|||
|
|||
Counting an entry to a cell
You have an answer at your duplicate posting - please do not multi-
post. Pete On Aug 7, 10:25*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
|
|||
|
|||
Counting an entry to a cell
Nae bother Pete. As said, I've been getting an error tellimg me there a
problem with the system. "Pete_UK" wrote: You have an answer at your duplicate posting - please do not multi- post. Pete On Aug 7, 10:25 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 |
Thread Tools | |
Display Modes | |
|
|