Hello, I am trying to get my SUMPRODUCT formula working properly. I would like the 'Total Project Hours' sheet, under the packing column to sum the total time for any tasks listed as 'Packing' and 'Crate making' (found in column L in the sheet named 'Data').
My formula so far is:But it is not working...Please Login or Register to view this content.
I have attached the workbook,thanks!
Bookmarks