Link to home
Create AccountLog in
Avatar of Simonrepro
Simonrepro

asked on

Complicated stock ordering Sum needs fixing

Hi,

In the attached spread sheet worksheet 'Order' cell C3 and below are not calculating correctly, can you let me know what the problem is please?

Regards


Simon
TEST.xls
ASKER CERTIFIED SOLUTION
Avatar of BusyMama
BusyMama
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ragnarok89
ragnarok89

I see two possible issues:

your formula contains SUMIF(Stock!A$2:A$310,A4,Stock!#REF!) above all else, the #REF will cause your formula to fail.

Secondly, I believe your formula is failing when calculating [b](Budgets!B$2:P$2<=D$2)[/b] I believe that either the syntax is wrong, or this needs to be an array formula.

Al
Avatar of Simonrepro

ASKER

Thanks!