Brian Barker wrote: > At 03:12 24/10/2008 +0000, Girard Aquino wrote: >> I got the new column, ... > > Good-oh! > >> ... but I am having difficulty representing characters in the >> countif(). I am using =COUNTIF(D8:D133;"\"). > > That will count those cells which contain a backslash and nothing > else, of course. Is that what you want? Since my example didn't use > any backslashes, I can't guess what you are trying to do. > >> i tried to replace the formatting of the new column into text, ... > > That's unlikely to be your problem, I think. Anything potentially > containing a backslash has to be text, doesn't it? > >> ... but can't get the desired result. I know it's probably a problem >> with my syntax. > > Are you trying to search for cells containing a backslash, rather than > those consisting of a backslash? That's more complex. Note that the > results will depend on your setting at Tools | Options... | > OpenOffice.org Calc | Calculate | Enable regular expressions in > formulas. And a backslash is a peculiarly confusing character to > choose in your scheme (if that is what you have done), since it is > also the escape character for regular expressions. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > I totally had problems with syntax and after reviewing wild characters, I got it to work with this: =COUNTIF($Scratch.A2:A123;"\"). But I had to change 1 to 2 for Feb, 3 for March, and so on... this works and I just have to make space for =sum(cells of 1st qtr) to get the quarterly figures.
is there a simpler or other automated way of doing the formula you could think of? (just for learning's sake) thank you. _________________________________________________________________
