SumIf combined with Isnumber or Match?

**hunt0035** · 10-25-2012, 02:34 PM

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

**jeffreybrown** · 10-25-2012, 02:36 PM

Hello & Welcome to the Forum,

How about a sample file with the results you expect?

--------------------------------------------------------

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**hunt0035** · 10-25-2012, 03:01 PM

So for Client Id 1030 Paul Total would be 52.5

**jeffreybrown** · 10-25-2012, 03:05 PM

It seems you are looking for on Sheet1...

=SUMIF(Sheet2!$A$2:$A$52,Sheet1!A2,Sheet2!$D$2:$D$52)

...copied down

**e.isayev** · 10-25-2012, 03:11 PM

=IFERROR(IF(MATCH(A2,Sheet2!A:A,0),SUMIF(Sheet2!A:A,Sheet1!A2,Sheet2!D:D),0),0)

**hunt0035** · 10-25-2012, 03:21 PM

Jeffrey,

Thanks That nailed it, I was dancing all around the same, but kept adding an unneeded (=)

I look forward to this site.

**jeffreybrown** · 10-25-2012, 03:29 PM

Awesome, glad it works out for you.

---------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save