Hey Pros,
Summary:
I have a spreadsheet
the top row from left to right is displaying dates, from oldest to most recent.
A column, has a list of items that need to be compared.
Per each item, are quantities on the row per column of the date.
Looking a Tab Sheet2, you can see the formula I"m trying to do comes back as #value, I'm not sure why.
I'm trying to sum across rows, with the conditions of of that particular row has the same Item Number, and if its in the columns that are before the date which is stated in 1 particular cell.
the logic I tried to use in the formula might better explain the goal, please help.
I'd love to know why it didn't work, to better learn what my error was.
I've attached the document.
Bookmarks