I am trying to use sumif for multiple criteria. I need A to = A and B to = B
and provide a sum of a colum if these two criteria are met.

SHEET 1 SHEET 1 SHEET 1 SHEET 2 SHEET 2
A Book 500.00 A
Book
B Copy 675.00 B
Copy
C DVD 950.00 C
DVD

I need a formula that says...... If A in sheet 1 = A in sheet 2 AND Book in
Sheet 1 = Book in Sheet 2, give me the sum of 500.00.

I have tried using =SUMIF and =DSUM and =SUMPRODUCT but can't get any of
them to work.

Can someone please help me!

In Sheet2:

=SUMPRODUCT((Sheet1!$A$2:$A$100=A2)*(Sheet1!$B$2:$ B$100=B2)*($C$2:$C$100))

HTH
Kostis Vezerides



Pcakes wrote:
I am trying to use sumif for multiple criteria. I need A to = A and B to = B
and provide a sum of a colum if these two criteria are met.

SHEET 1 SHEET 1 SHEET 1 SHEET 2 SHEET 2
A Book 500.00 A
Book
B Copy 675.00 B
Copy
C DVD 950.00 C
DVD

I need a formula that says...... If A in sheet 1 = A in sheet 2 AND Book in
Sheet 1 = Book in Sheet 2, give me the sum of 500.00.

I have tried using =SUMIF and =DSUM and =SUMPRODUCT but can't get any of
them to work.

Can someone please help me!

Sumproduct is really your best option for summing an array with multiple
criteria. Here is a link to an explanation of SumProduct...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Pcakes" wrote:

I am trying to use sumif for multiple criteria. I need A to = A and B to = B
and provide a sum of a colum if these two criteria are met.

SHEET 1 SHEET 1 SHEET 1 SHEET 2 SHEET 2
A Book 500.00 A
Book
B Copy 675.00 B
Copy
C DVD 950.00 C
DVD

I need a formula that says...... If A in sheet 1 = A in sheet 2 AND Book in
Sheet 1 = Book in Sheet 2, give me the sum of 500.00.

I have tried using =SUMIF and =DSUM and =SUMPRODUCT but can't get any of
them to work.

Can someone please help me!