Help!

I am trying to make it so that column 'D' in my worksheet gives me the total
of column 'A' divided by column 'C' (where not 'Part Change', but only
between each occurance of it) as there is over 15000 rows i do not want to do
it manually, can anyone shead some light on this for me. Thanks

There is a small example of the data below if required.


A B C D

19 7 Part Change
18 7
18 7
16 7
7 7 Part Change
8 5
14 5
7 5 Part Change
10 5
13 5
2 5 Part Change
14 11
19 11 Part Change
22 11 Part Change

Hi Adam,

Your data layout is not very clear in my newsreader.
Do you mean
so that column 'D' in my worksheet gives me the total of column 'A' divided
by column 'B' (where 'C'not 'Part Change'?

What if Col 'C' IS 'Part Change'? Empty?

Try in D1:

=IF(C1="Part Change","",A1/B1)

and copy down as far as you need

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Adamw3" wrote in message
...
I am trying to make it so that column 'D' in my worksheet gives me the
total
of column 'A' divided by column 'C' (where not 'Part Change', but only
between each occurance of it) as there is over 15000 rows i do not want to
do
it manually, can anyone shead some light on this for me. Thanks

There is a small example of the data below if required.


A B C D

19 7 Part Change
18 7
18 7
16 7
7 7 Part Change
8 5
14 5
7 5 Part Change
10 5
13 5
2 5 Part Change
14 11
19 11 Part Change
22 11 Part Change

Hi,
If your information starts in row 2 in D2 enter

=if(C2="Part Change","",A2/B2)

copy formula down


"Adamw3" wrote:

I am trying to make it so that column 'D' in my worksheet gives me the total
of column 'A' divided by column 'C' (where not 'Part Change', but only
between each occurance of it) as there is over 15000 rows i do not want to do
it manually, can anyone shead some light on this for me. Thanks

There is a small example of the data below if required.


A B C D

19 7 Part Change
18 7
18 7
16 7
7 7 Part Change
8 5
14 5
7 5 Part Change
10 5
13 5
2 5 Part Change
14 11
19 11 Part Change
22 11 Part Change

Adamw3 wrote:
I am trying to make it so that column 'D' in my worksheet gives me the total
of column 'A' divided by column 'C' (where not 'Part Change', but only
between each occurance of it) as there is over 15000 rows i do not want to do
it manually, can anyone shead some light on this for me. Thanks

There is a small example of the data below if required.


A B C D

19 7 Part Change
18 7
18 7
16 7
7 7 Part Change
8 5
14 5
7 5 Part Change
10 5
13 5
2 5 Part Change
14 11
19 11 Part Change
22 11 Part Change



Using the data above, what do you expect in column D?