Just to clarify...
if A1 of current=A1 of another sheet, and B1 of current sheet=B2 of another
sheet, and etc. for 4 columns, then sum F5.... then I need it to check 5000
lines...

What is the proper formula for this?

"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?