I have created a SUMIF formula that appears to be correct, but continues to
return a "#Value!" in the field I have created the formula. If I look at the
area where the different pieces are filled in the correct answer is appearing
there, but the "#Value!" still is all I see in the field on my Excel
spreadsheet.

I went online to look for help there and I am already incorporating their
suggestions. I am looking to see if there is anyone out there that can
possibly look at the formula I have to provide some suggestions.

Thank you!