Help with conditional count.

  • Thread starter Thread starter Tech.Zoan
  • Start date Start date
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
 
Try this:

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

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

Regards,

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

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

Similar Threads

Help needed 0
Counting unique values in multiple columns 4
How to count cells with conditional formatting 3
Syntax help please 7
Array problem. Comparing data. 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Nested IF conditions 3
Count Conditional formating data 3

Back
Top