T Tech.Zoan Feb 8, 2008 #1 How do I tell Excel to only add amounts in column C if they have been flagged with an "X" in the adjacent column B? TIA
How do I tell Excel to only add amounts in column C if they have been flagged with an "X" in the adjacent column B? TIA
R Ron Coderre Feb 8, 2008 #2 Try this: =SUMIF(B1:B100,"x",C1:C100) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP)
Try this: =SUMIF(B1:B100,"x",C1:C100) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP)
