Hoping someone can please help me....

Running Excel 2003, I have a worksheet, on which each row represents product
shipment data.

L2:L133 represents product shipment date
P1 represents current date
Column O=NETWORKDAYS(L2,,$P$1)-1
To calculate the actual # of days elapsed between shipment and current date.

N2:N133=Shipment value
N134="Total" (name defined)

Q1=SUMIF(O:O,"=12",N2:N133) To obtain shipped total matching or exceeding
12 days.
R1=Q1/Total, to obtain % of total which has met or exceeded 12 days.

Formulas seem to calculate correctly, yet if I go back and "add the shipment
values which match or exceed the desired 12 days, I get a different total,
than the system calculates in Q1.

Any ideas?

TIA,
Sandi

Hi Sandi,

One possibility could be that your calculations is set to Manual.

Try and go to Tools - Options - Calculations and then set
Calculations to Automatic.

Regards,
Bondi

I think your problem might be in the SUMIF formula, as you have different
sized ranges. Try

=SUMIF(O2:O133,"=12",N2:N133)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RUSH2CROCHET" wrote in message
...
Hoping someone can please help me....

Running Excel 2003, I have a worksheet, on which each row represents
product
shipment data.

L2:L133 represents product shipment date
P1 represents current date
Column O=NETWORKDAYS(L2,,$P$1)-1
To calculate the actual # of days elapsed between shipment and current
date.

N2:N133=Shipment value
N134="Total" (name defined)

Q1=SUMIF(O:O,"=12",N2:N133) To obtain shipped total matching or
exceeding
12 days.
R1=Q1/Total, to obtain % of total which has met or exceeded 12 days.

Formulas seem to calculate correctly, yet if I go back and "add the
shipment
values which match or exceed the desired 12 days, I get a different total,
than the system calculates in Q1.

Any ideas?

TIA,
Sandi

Bob:

That was precisely it! Thanks for showing me the error of my ways......
<<BIG GRIN

Have a great day!
Sandi

"Bob Phillips" wrote:

I think your problem might be in the SUMIF formula, as you have different
sized ranges. Try

=SUMIF(O2:O133,"=12",N2:N133)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RUSH2CROCHET" wrote in message
...
Hoping someone can please help me....

Running Excel 2003, I have a worksheet, on which each row represents
product
shipment data.

L2:L133 represents product shipment date
P1 represents current date
Column O=NETWORKDAYS(L2,,$P$1)-1
To calculate the actual # of days elapsed between shipment and current
date.

N2:N133=Shipment value
N134="Total" (name defined)

Q1=SUMIF(O:O,"=12",N2:N133) To obtain shipped total matching or
exceeding
12 days.
R1=Q1/Total, to obtain % of total which has met or exceeded 12 days.

Formulas seem to calculate correctly, yet if I go back and "add the
shipment
values which match or exceed the desired 12 days, I get a different total,
than the system calculates in Q1.

Any ideas?

TIA,
Sandi