Vlookup/Sumifs/Sumproducts

Hi there, I am working on a project to determine hours worked on specific job categories. I was using Sumifs to meet the criteria, however I am limited because I can't seem to put an Or option in so I am getting double counts. I've read you can use Vlookups for this but I can't figure it out. Anyone have any idea how I get what I want.

I want to sum the values in FH, based on if the file is "closed", an "INS", and has "y" either under FA or SP. I plan on doing this for FH, then use the same formula to determine FT, DH, and DT.
(its the FA and SP columns that give me double count because some of them have "y" under both.

thank you
Holly

Hi Holly,

Based on your example, try this to determine your sum for FH:


To change the formula for FT, DH, and DT, just change the range reference Q2:Q18 to the applicable range.

Cheers,

Thank you!! life saver