G
Guest
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!
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!