Sum Data if Column B = Q

S

Seanie

I wish to sum all data in Sheet2 Column J, if the value in Sheet2
Column B = The value in Sheet1 Column A

I've tried =SUMPRODUCT(PC_Month_Locations=A8,PC_Month)

Named Ranges above used instead of absolute references
 
D

Dave Peterson

If your ranges are defined correctly:

=sumif(pc_month_locations,a8,pc_month)

If you wanted to use =sumproduct():
=SUMPRODUCT(--(PC_Month_Locations=A8),PC_Month)

Adjust the ranges to match--but you can't use whole columns (except in xl2007+).

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top