I have a excel sheet that I want to divide two long rows of cell by each
other. I want to divide n6 through N20 / M6 through M20. In the N row I have
a percent and I want to divide it by Time in the M row. Please help!!

In cell O6 enter:

=N6/M6

Copy O6 from O7 thru O20
--
Gary's Student


"oxicottin" wrote:

> I have a excel sheet that I want to divide two long rows of cell by each
> other. I want to divide n6 through N20 / M6 through M20. In the N row I have
> a percent and I want to divide it by Time in the M row. Please help!!

=SUM(IF(M6:M20<>"",N6:N20/M6:M20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"oxicottin" <(E-Mail Removed)> wrote in message
news:499F02CE-0847-4107-8A4E-(E-Mail Removed)...
> I have a excel sheet that I want to divide two long rows of cell by each
> other. I want to divide n6 through N20 / M6 through M20. In the N row I
have
> a percent and I want to divide it by Time in the M row. Please help!!

the formula =SUM(IF(M6:M20<>"",N6:N20/M6:M20)) didnt work it gave me a
#value. My boss explained what he wanted better to me let me try again. I
have a row that is cells K6 through K20 that are in a time format like 2:00.
I want to divide those cells by the cells M6 through M20 which are in a
percent format. Then I want to multiply the number i get by 100 to give me a
percent. what im using this for mabe it will help if i explain? We run
machines for a 8hr period or less which we call hours worked, cells M6-M20
sometimes the machines are down or not running in those hours which we call
delay time cells K6-K20 I needed a % that the machine was down for the amount
of hours worked.

"oxicottin" wrote:

> I have a excel sheet that I want to divide two long rows of cell by each
> other. I want to divide n6 through N20 / M6 through M20. In the N row I have
> a percent and I want to divide it by Time in the M row. Please help!!

Did you array enter it like I said?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"oxicottin" <(E-Mail Removed)> wrote in message
news:8B4B2129-C1AA-4F01-8E64-(E-Mail Removed)...
> the formula =SUM(IF(M6:M20<>"",N6:N20/M6:M20)) didnt work it gave me a
> #value. My boss explained what he wanted better to me let me try again. I
> have a row that is cells K6 through K20 that are in a time format like
2:00.
> I want to divide those cells by the cells M6 through M20 which are in a
> percent format. Then I want to multiply the number i get by 100 to give
me a
> percent. what im using this for mabe it will help if i explain? We run
> machines for a 8hr period or less which we call hours worked, cells M6-M20
> sometimes the machines are down or not running in those hours which we
call
> delay time cells K6-K20 I needed a % that the machine was down for the
amount
> of hours worked.
>
> "oxicottin" wrote:
>
> > I have a excel sheet that I want to divide two long rows of cell by each
> > other. I want to divide n6 through N20 / M6 through M20. In the N row I
have
> > a percent and I want to divide it by Time in the M row. Please help!!

Yes it says not valid in merged cells but i have no merged cells in that area?

"Bob Phillips" wrote:

> Did you array enter it like I said?
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "oxicottin" <(E-Mail Removed)> wrote in message
> news:8B4B2129-C1AA-4F01-8E64-(E-Mail Removed)...
> > the formula =SUM(IF(M6:M20<>"",N6:N20/M6:M20)) didnt work it gave me a
> > #value. My boss explained what he wanted better to me let me try again. I
> > have a row that is cells K6 through K20 that are in a time format like
> 2:00.
> > I want to divide those cells by the cells M6 through M20 which are in a
> > percent format. Then I want to multiply the number i get by 100 to give
> me a
> > percent. what im using this for mabe it will help if i explain? We run
> > machines for a 8hr period or less which we call hours worked, cells M6-M20
> > sometimes the machines are down or not running in those hours which we
> call
> > delay time cells K6-K20 I needed a % that the machine was down for the
> amount
> > of hours worked.
> >
> > "oxicottin" wrote:
> >
> > > I have a excel sheet that I want to divide two long rows of cell by each
> > > other. I want to divide n6 through N20 / M6 through M20. In the N row I
> have
> > > a percent and I want to divide it by Time in the M row. Please help!!
>
>
>