Ok my brain has been wrapped around this too long, I feel like I am staring in the Fridge looking for ketchup and its sitting right in front of me, I need another set of eyes right now.

I am trying to Add client sales by customer ID from 2 different sheets.

so:

If Sheet 1 Column A (Client Id) matches Sheet 2 Column A (client ID) ADD up all values in Sheet 2 Column D (Sales) each time it occurs, and return the total.

Thanks