If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum Data if Column B = Q
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 |
#2
|
|||
|
|||
Sum Data if Column B = Q
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 he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html Seanie wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
Sum Data if Column B = Q
Bingo, works great, Thanks
|
#4
|
|||
|
|||
Sum Data if Column B = Q
=SUMIF(PC_Month_Locations,A8,PC_Month)
"Seanie" wrote: 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 . |
Thread Tools | |
Display Modes | |
|
|