Countif Statement

[lalahaedong_excel]

How would I do a Nested CountIF statement where I countif and then do a calculation based on the results?

see formula below

=COUNTIF(C6:C9,"*Direct*")+COUNTIF(C6:C9,"*Fixed*")+COUNTIF(C6:C9,"*Travel*")

want value just to be "1" if any a true and then multiple the "1" value by $125

[gmr4evr1]

IT's not clear (at least not to me) what it is you are wanting. Can you attach a sample workbook with dummy data of what you have and the results you are expecting?

[lalahaedong_excel]

I attached a simple file of what I am trying to achieve

[Crooza]

Why not just this

Please Login or Register  to view this content.

[lalahaedong_excel]

Im not explaining properly. I have attached the problem with my desired results.

[Crooza]

Looks like you need a simple OR statement but you're using merged cells which could ultimately lead to disaster. I'd reformat your sheet to remove the merged cells first then apply an OR statement but I'm not clear on what you're looking for - is it simply the presence of the word "YES" in one or more cells?

[FlameRetired]

Unmerge the cells. Then try this in B10 and fill down.

Please Login or Register  to view this content.