Hi. I joined a while back to get help with a spreadsheet but I managed to figure it out myself.
Im now working on another spreadsheet and Im still struggling with what formula I should use and how to implement it. I believe SUMPRODUCT is what i need but I cant get it to work.
Basically I want to sum up cells in a column F. But only for the rows where column A matches a date range and Column E says 'Pack'.
Ive upload a snippet of the sheet can someone have a quick look?
Ive took out all unnecessary columns and added comments to show exactly what Im trying to do. May make a bit more sense.
Thanks for any help.
Aaron.
Bookmarks