Good morning,

I need some assistance with below. I have this formula in every other row - then I have a grand-total of these values in a Range Name (alpha-numeric). I am attempting to use this range name along with another range name in a calculation: =sum(RAWMATERIAL426 - DAILYRAWING426) and I am receiving the #VALUE!.

I understand it is attempting to calculate a string but not sure...Is it the Range Name(s) that are producing this #VALUE! error because all of the cells involved in the formula with the 'number format.' Or is it the array triggering the error.


1) 1st RANGE NAME FOR THE GRAND-TOTAL IS RAWMATERIAL426 (426 = daily date)

Formula: copy to clipboard 
 =IF(ISERROR(INDEX(FlourTbl!IngAmt,MATCH($B29 & $A29,FlourTbl!RecCode&FlourTbl!IngCode,0))*B30),"",INDEX(FlourTbl!IngAmt,MATCH($B29 & $A29,FlourTbl!RecCode&FlourTbl!IngCode,0))*B30)


2) 2nd RANGE NAME: DAILYRAWING426

Can someone please assist me with creating a better formula as soon as possible.

Thanks a bunch. Deanna