I have about 5 different dates (08/25/06) in a row E4,F4,G4,H4,I4 These rows
continue for about 100 rows down. I want a total count for each column. But
what i need is when i add a date it will subtract it from the previous cells
dates column and add it to the new column and so on. I'm trying to keep a
time record of a parts and at the same time know which column it is in. Hope
someone can help. Thanks.

Chas,

A couple of row examples would help a lot.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Chas" wrote:

I have about 5 different dates (08/25/06) in a row E4,F4,G4,H4,I4 These rows
continue for about 100 rows down. I want a total count for each column. But
what i need is when i add a date it will subtract it from the previous cells
dates column and add it to the new column and so on. I'm trying to keep a
time record of a parts and at the same time know which column it is in. Hope
someone can help. Thanks.

SAND BLST BAKE PRIME PAINT SELL
C D E F G
1 O8/20/06 O8/22/06 O8/24/06 O8/27/06 O8/30/06
2 O8/15/06 O8/18/06 O8/25/06
3 O8/16/06 O8/21/06 O9/29/06
4 O9/20/06 O9/25/06 O9/28/06
5 O8/20/06

TOT= 1 0 0 1 3
Each row is a part. I want to see how many are in a column at a glance. so
each time I move it to the next step it adds it to that column and subtracts
it from the last. also as you can see not all parts go through the same
steps. I put the actual TOTAL count in each column so you can see how it
would look. i know i have to add another row between each column for the
function but i'll hide it when i get it right. I've tried but it's kicking my
but. Thanks, hope you can help. Chas

=COUNTA(C1)IF(D1,E1,F1,G1=<1,"1") One of my bad functions i can't get to work.

"Martin Fishlock" wrote:

Chas,

A couple of row examples would help a lot.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Chas" wrote:

I have about 5 different dates (08/25/06) in a row E4,F4,G4,H4,I4 These rows
continue for about 100 rows down. I want a total count for each column. But
what i need is when i add a date it will subtract it from the previous cells
date column and add it to the new column and so on. I'm trying to keep a
time record of a parts and at the same time know which column it is in. Hope
someone can help. Thanks.

I figured it out myself. Thanks anyway:) here is the function:
=COUNTA(H5)=IF(COUNTA(J5,L5,N5,P5,R5,T5,V5,X5,Z5,A B5,AD5,AF5),"0",1)

"Chas" wrote:


SAND BLST BAKE PRIME PAINT SELL
C D E F G
1 O8/20/06 O8/22/06 O8/24/06 O8/27/06 O8/30/06
2 O8/15/06 O8/18/06 O8/25/06
3 O8/16/06 O8/21/06 O9/29/06
4 O9/20/06 O9/25/06 O9/28/06
5 O8/20/06

TOT= 1 0 0 1 3
Each row is a part. I want to see how many are in a column at a glance. so
each time I move it to the next step it adds it to that column and subtracts
it from the last. also as you can see not all parts go through the same
steps. I put the actual TOTAL count in each column so you can see how it
would look. i know i have to add another row between each column for the
function but i'll hide it when i get it right. I've tried but it's kicking my
but. Thanks, hope you can help. Chas

=COUNTA(C1)IF(D1,E1,F1,G1=<1,"1") One of my bad functions i can't get to work.

"Martin Fishlock" wrote:

Chas,

A couple of row examples would help a lot.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Chas" wrote:

I have about 5 different dates (08/25/06) in a row E4,F4,G4,H4,I4 These rows
continue for about 100 rows down. I want a total count for each column. But
what i need is when i add a date it will subtract it from the previous cells
date column and add it to the new column and so on. I'm trying to keep a
time record of a parts and at the same time know which column it is in. Hope
someone can help. Thanks.