2015-10-17 20:25:42 +0200 received badge ● Famous Question (source) 2015-10-17 20:25:42 +0200 received badge ● Notable Question (source) 2015-10-17 20:25:42 +0200 received badge ● Popular Question (source) 2014-12-23 17:16:47 +0200 received badge ● Popular Question (source) 2014-12-23 17:16:47 +0200 received badge ● Famous Question (source) 2014-12-23 17:16:47 +0200 received badge ● Notable Question (source) 2013-07-25 23:06:44 +0200 received badge ● Notable Question (source) 2013-07-25 23:06:44 +0200 received badge ● Famous Question (source) 2013-07-25 23:06:44 +0200 received badge ● Popular Question (source) 2013-03-03 01:26:05 +0200 received badge ● Famous Question (source) 2013-02-19 23:44:31 +0200 received badge ● Notable Question (source) 2013-02-19 23:44:31 +0200 received badge ● Popular Question (source) 2012-08-30 20:39:32 +0200 asked a question Counting Rows Hello I am trying trouble with the ROWS function in LO 3.5.0rc3 on my iMac. If I put the formula =ROWS($A$1:$A1) and copy and past it into cells A2 to A5 I get the following formulas: A2=ROWS($A$2:$A2) result =1 A3=ROWS($A$3:$A3) result =1 A4=ROWS($A$4:$A4) result =1 A5=ROWS($A$5:$A5) result =1 What I would expect and need is: A2=ROWS($A$1:$A2) result =2 A3=ROWS($A$1:$A3) result =3 A4=ROWS($A$1:$A4) result =4 A5=ROWS($A$1:$A5) result =5 For some reason the absolute cell reference to cell$A\$1 does not stick. It does not matter which column I try it in. However if I save the file and open it in Open Office I can copy and paste the formula with no trouble, save the file, reopen in LO and it works fine. But that is a pain of a work around. Any ideas? Thanks MRB 2012-08-28 01:40:26 +0200 asked a question Countif for letter in middle of text Hello I am working on an iMac and trying to count the number of 8 digit codes in a column that have a particular letter in the 6th spot with =countif(A1:A10,".C.") but it does not return the correct number. I have also tried ".....C.." and "......C..." and ".*.C.*." Any ideas Thanks 2012-08-27 19:17:54 +0200 received badge ● Scholar (source) 2012-08-24 01:53:56 +0200 asked a question Countif on iMac I would like to count the number of words in a column that end with a certain letter. Countif works fine for counting how many start with a certain letter but will not work to count words that end or contain a certain letter. For example: COUNTIF(A1:A11,"c.") works fine but COUNTIF(A1:A11,".c") just gives 0. Any ideas? Thanks 2012-07-26 17:33:07 +0200 received badge ● Student (source) 2012-07-16 18:22:26 +0200 commented answer Countif based on last character in text string Would any one have a suggestion on a SUMPRODUCT & REPLACE formula that might work? Or a different work around? 2012-07-16 18:20:07 +0200 commented answer Countif based on last character in text string Thanks, I have also tried a workaround using SUMPRODUCT and REPLACE but still get 0. 2012-07-16 16:34:15 +0200 commented answer Countif based on last character in text string I have double checked for blank spaces following the last character and also manually entered a sample list on a new sheet and still it returns 0. The same problem exists when I try it with Open Office. I am running OSX Snow Leopard on an iMac. 2012-07-16 03:45:08 +0200 commented question Countif based on last character in text string Yes, regular expressions are enabled. As a result countit based on the first character works for example =countif(A2:A12,"W.*") returns 1 but countif based on the last character does not. 2012-07-16 00:30:52 +0200 answered a question Countif based on last character in text string Hello Thanks but that gives a result of 0. FB 2012-07-15 23:36:12 +0200 received badge ● Editor (source) 2012-07-15 23:27:54 +0200 asked a question Countif based on last character in text string I have a column of text based codes. Some end with F, some with A and some with - . A1 KnotsP-A A2 SaucyF-- A3 B-SweP-F A4 StancF-F A5 RoothF-F A6 GrainF-- A7 RavenP-F A8 GermaP-A A9 ParkeF-F A10 LucieFE- A11 Top MPEF A12 WarneF-F I would like to be able to count how many end with F. I have tried a number of variations suce as: =countif(A1:A12,.f) and =countif(A1:A12,".F") and =countif(A1:A12,"=.F") but they do not work. =countif(A1:A12,"W.") works, returns 1 Please note that the formulae include the wildcard asterix but they don't seem to show up on this blog. Any help would be great. Thanks FB