Hello,
I have an inventory database that I have used for a long time with no problems until today.
There are 2 columns in the Database that pull from separate workbooks to obtain their values. One uses a SUMIF and the other uses SUMPRODUCT, but throughout the day both have separately broken while trying to fix other things in the excel files that are referenced.
They both come up as "#VALUE!"
As of right now, the column that is not working is the one using the SUMIF formula.
I have attached a picture of the layout of the workbook (the green columns are usually where it says #Value!).
Column E's formula:
Column F'S formula:Please Login or Register to view this content.
Is there a different method I could go about to reference the cells values?Please Login or Register to view this content.
Any help is greatly appreciated!
Miranda
example1.PNG
Bookmarks