I can't get any of the formulas to work... can someone help please?

I am trying to add all of column I if 5 criteria match. I have tried the
sum product and it isn't working. I really need help with this ASAP.

Thanks!

"Brad_A" wrote:

Okay, I am trying to do the following:
I am trying to set up a function that if 4 columns match then sum the 5th
column. It needs to check about 5000 lines with this formula. I don't know
how to set it up to where it checks all statements. Can someone please help
me with the proper formula?