Hi

Try something like this:
=IF(OR(A2="RC",A2="NC",A2="RS"),"Complete","Not done")
You can then fill this formula down all of your rows. For a total use
COUNTIF():
=COUNTIF(C2:C1000,"Completed")

Andy.



"redneck joe" wrote
in message ...

Hello - need help with a formula. I've tried searching, looked through
about 30 threads but can't find a match.


I need to search a column for 3 different parameters ("RC","NC","RS")
and if it finds it in a cell, I need to go to specific cell in another
column (same row) and read ("complete" or "not done") then total all
those findings into the formula cell.


I try to learn this stuff on my own, but my brain is just too tired
today...

Thanks
rdj


--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile:
http://www.excelforum.com/member.php...o&userid=32570
View this thread: http://www.excelforum.com/showthread...hreadid=523676