Hello there, thanks in advance. I am quite sure this is simple but cant
figure it out.

Ok, My G4:G135 fields all have employee names

My F4:F135 fields all have the payment amount for that job

Now, I have 20 employee's through all these fields.

I want to find a certain employee in G4:G135 and find all of his payments,
then add them up to produce the total.

While this doesnt work, it should explain what I am trying to do:

=IF(G4:G140,"Jackson"), SUM(F4:F140 "Jackson")

As you can see, I am not too cluey on this. Please let me know if you need
further info or screenshot