| Forum Home | ||||
| PC World Chat | ||||
| Thread ID: 119726 | 2011-08-07 05:15:00 | XL Question | B.M. (505) | PC World Chat |
| Post ID | Timestamp | Content | User | ||
| 1221362 | 2011-08-07 05:15:00 | Ok, I have say Column “A” with entries such as: 2(Sold) 5 7 1(Sold) 6 10 21 And I want to count the number of cells with (Sold) in them. The numbers prefixing the (Sold) are of no consequence for this calculation. I thought something along the lines of =countif(A1:A10,Sold) but of course that doesn’t work. (Well doesn’t for me). The answer I’m looking for is of course 2 in the above example. I was thinking along the lines of a “Wild Card” prefixing the Sold, say, *.(Sold) but that doesn’t work either. So I thought I’d check with the XL experts to see if it can be done. :D |
B.M. (505) | ||
| 1221363 | 2011-08-07 06:16:00 | Cancel that, all fixed. :thumbs: | B.M. (505) | ||
| 1 | |||||