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

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

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

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