We help IT Professionals succeed at work.

# Complicated stock ordering Sum needs fixing

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

## View Solution Only

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!

Commented:
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

Commented:
Thanks!