Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count date in every 4th cell down column
i asked this question yesterday but the lovley suggestions did not work
because i did not give all the information i needed to. Oops! here's what my data looks like: A B 1 tim smith 27-Jun 2 11 vine st resch. 3 tall, mi 41151 29-Jun 4 000-000-0000 5 lee long 8-Aug 6 box 5 7 large, oh 11175 order 8 111-111-1111 i need to count the dates!! in the cells next to the names, every 4th cell. the dates need counted as 1 conntact per date. only counting the dates next to the names not any other dates that may appear (ie rescheduled date) So i need to count dates b1, b5, b9... on a very large list of clients Thanks for your time and help!!! Ash |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count date in every 4th cell down column
Ashley,
I'm confused. if there is always four rows of information for each name, and there is always a date in B next to each name, can't you count the number of rows in A and divide by 4? Don "Ashley" wrote in message ... i asked this question yesterday but the lovley suggestions did not work because i did not give all the information i needed to. Oops! here's what my data looks like: A B 1 tim smith 27-Jun 2 11 vine st resch. 3 tall, mi 41151 29-Jun 4 000-000-0000 5 lee long 8-Aug 6 box 5 7 large, oh 11175 order 8 111-111-1111 i need to count the dates!! in the cells next to the names, every 4th cell. the dates need counted as 1 conntact per date. only counting the dates next to the names not any other dates that may appear (ie rescheduled date) So i need to count dates b1, b5, b9... on a very large list of clients Thanks for your time and help!!! Ash |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count date in every 4th cell down column
i sorry i didn't make it very celar - i'm really struggeling with this entire
project :( - the date indicates when a client has been contacted for a certian reason -- some clients have not been contacted. no date by the name exists. (there could be other information in the cells adjacent to the address) but the date by the name is not there. please let me know if you have any other questions i am very thankful for your help ash "Don" wrote: Ashley, I'm confused. if there is always four rows of information for each name, and there is always a date in B next to each name, can't you count the number of rows in A and divide by 4? Don "Ashley" wrote in message ... i asked this question yesterday but the lovley suggestions did not work because i did not give all the information i needed to. Oops! here's what my data looks like: A B 1 tim smith 27-Jun 2 11 vine st resch. 3 tall, mi 41151 29-Jun 4 000-000-0000 5 lee long 8-Aug 6 box 5 7 large, oh 11175 order 8 111-111-1111 i need to count the dates!! in the cells next to the names, every 4th cell. the dates need counted as 1 conntact per date. only counting the dates next to the names not any other dates that may appear (ie rescheduled date) So i need to count dates b1, b5, b9... on a very large list of clients Thanks for your time and help!!! Ash |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count date in every 4th cell down column
Ashley
Try: =SUMPRODUCT(--(MOD(ROW(B1:B100),4)=1),--ISNUMBER(B1:B100)) Don "Ashley" wrote in message ... i sorry i didn't make it very celar - i'm really struggeling with this entire project :( - the date indicates when a client has been contacted for a certian reason -- some clients have not been contacted. no date by the name exists. (there could be other information in the cells adjacent to the address) but the date by the name is not there. please let me know if you have any other questions i am very thankful for your help ash "Don" wrote: Ashley, I'm confused. if there is always four rows of information for each name, and there is always a date in B next to each name, can't you count the number of rows in A and divide by 4? Don "Ashley" wrote in message ... i asked this question yesterday but the lovley suggestions did not work because i did not give all the information i needed to. Oops! here's what my data looks like: A B 1 tim smith 27-Jun 2 11 vine st resch. 3 tall, mi 41151 29-Jun 4 000-000-0000 5 lee long 8-Aug 6 box 5 7 large, oh 11175 order 8 111-111-1111 i need to count the dates!! in the cells next to the names, every 4th cell. the dates need counted as 1 conntact per date. only counting the dates next to the names not any other dates that may appear (ie rescheduled date) So i need to count dates b1, b5, b9... on a very large list of clients Thanks for your time and help!!! Ash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
Count if date is between two dates and value in another column equ | Excel Worksheet Functions | |||
Value between 2 dates | Excel Worksheet Functions | |||
Count cells based on date range in another column | New Users to Excel |