Calculations seem to be off...
 

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

Calculations seem to be off...
 

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

Calculations seem to be off...
 

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

Calculations seem to be off...
 

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