I have attached the spreadsheet for your reference. I am wanting to use the sumifs function, but have not been able to get it to work. I’m fine with using named ranges, arrays, etc. My goal is to not have to create another column or sheet to get the calculation to work. I designed a diagram on sheet three to show what I am trying to do. Any guidance you have for this I would greatly appreciate the help.