try

=IF(AND(J9="yes",AK9="yes",or(AE9="Express",AE9="E press",AE9="EXPU")),sum(AE9:AE200),"")
Are you sure on summiing the AE9 since you are looking for text in AE9?

"lostinformulas" wrote:


I need help adding another condition to my formula.I need AE9 to =
"Epress" or ="EXPU". At this time it only returns a response for
="Express"

=IF(AND(J9="yes",AK9="yes",AE9="Express"),1,"")


I also need this formula to total the column. AE9:AE200.


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=550065