Help with conditional count.

T

Tech.Zoan

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

Try this:

=SUMIF(B1:B100,"x",C1:C100)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Top