We help IT Professionals succeed at work.

Complicated stock ordering Sum needs fixing

Simonrepro
Simonrepro asked
on
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
Comment
Watch Question

Commented:
Did you delete some cells, rows or columns in the sheets titled Stock and/or Budget?  The formula is showing a #REF meaning it can't find some of the cells you originally defined.

For example, part of your formulas are:

SUMIF(Stock!A$2:A$310,A3,Stock!#REF!

Budgets!A$4:A$90=A4)*(Budgets!#REF!>=C$2)*(Budgets!#REF!<=D$2),Budgets!#REF!
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

Author

Commented:
Thanks!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.