paul_pearson
Board Regular
- Joined
- Mar 3, 2013
- Messages
- 181
Hi
I have in cell C140 the formula =countif(C14:C131,"ted") and this works fine except for in some cells between C14:C131 i have the names ted/paul in the same cell and therefore it does not count Ted....Please how do i change formula to include Ted even if it has another name next to it
Thanks
Excel 2010
Paul
I have in cell C140 the formula =countif(C14:C131,"ted") and this works fine except for in some cells between C14:C131 i have the names ted/paul in the same cell and therefore it does not count Ted....Please how do i change formula to include Ted even if it has another name next to it
Thanks
Excel 2010
Paul