I am using excel for preparing a schedule of Doors. For sorting the data i
have used the following formula
SUM(IF(D2:D2263=1,IF($H$1:$H$2263=E2269,IF($K$1:$K $2263=G2269,IF($E$1:$E$2263="A",$C$2:$C$2263,0),0) ,0),0))
which returns a #Value Error.
If i evaluate this formula through Insert<Fuction, i am getting the desired
result, if i evaluate the formula through formula auditing i get the error,
is this a bug in the programme.
The problem is in the if statement, Excel is not evaluating the condition
D2:D2263=1 as a whole but is only evaluating d2:d2263

Any help would be greatly appreciated.

Thank you.