Hi All,
I have a huge spreadsheet with multiple tabs and need to be able to sum up several different items with multiple criteria.

Sheet One has the Product and its status example is in the attached pic, it has many more rows than this for each project:

Data.png

I need to be able to total up each line of project by it's status in a summary file

I have tried different combinations of VLOOKUPs with SUMIFs and none seem to work

Any ideas ?

Thanks all