I have a workbook where there is nothing consistent or any named ranges. I
need to make a summary sheet and count everytime I have the word cable in the
entire workbook in column B. I have tried different variations of countif,
lookups and find but have not come up with a combination that works. My
restraint is that I can't have a macro for this workbook. I really need some
help, example below.


A B
1 Cable
2 FSR
3 FRK
4 Wind Meter
5 Laptop


Thanks in advance,
Carrie

--
Message posted via http://www.officekb.com