SUMIFS Help

**DpriceHmark** · 03-24-2011, 02:50 PM

I am trying to isolate certian criteria using a SUMIFS Formula (as I have two pieces of Criteria that need satisified before those numbers can be added).

the formual that I have now is:

=SUMIFS('Sched D Part 1'!$R$4:$R$1323,'Sched D Part 1'!$A$4:$A$1325,K34,'Sched D Part 1'!$B$4:$B$1325,J37)

As the criteria is located in another tab on the Excel Book.

K34 is T3200001
J37 is A

I need both of satisified before it should add the Values together.

I am currently getting a "#VALUE!" error and I have tried all kinds of ways to change.

As work prohibits moving information I cannot post the worksheet, I checked and tired changing the formats all kinds of stuff

Items listed in column B have a "Trim" Formual in them
Items listed in column A have a "Trim" Formual in them

Column B has a lot of "" blanks in them <-- maybe this needs populated?

Any help of any kind would be great! Let me know if you need any other information....

**NBVC** · 03-24-2011, 02:58 PM

The ranges need to be all the same size.. the first range is shorter by 2 rows.

**DpriceHmark** · 03-24-2011, 03:46 PM

Problem Solved!

Thank you!!!

**NBVC** · 03-24-2011, 03:56 PM

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

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