try
SUMproduct(D2:D2263=1)*($H$1:$H$2263=E2269)*($K$1: $K$2263=G2269)*($E$1:$E$2263="A")*$C$2:$C$2263)--Don GuillettSalesAid "Mayur Godbole" <Mayur wrote in ...I am using excel for preparing a schedule of Doors. For sorting the data i have used the following formulaSUM(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$22 63,0),0),0),0)) which returns a #Value Error. If i evaluate this formula through Insert<Fuction, i am getting thedesired result, if i evaluate the formula through formula auditing i get theerror, 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.