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:Please Login or Register to view this content.
2) 2nd RANGE NAME: DAILYRAWING426
Can someone please assist me with creating a better formula as soon as possible.
Thanks a bunch. Deanna