First time here? Check out the FAQ!

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 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 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.." 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. 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, 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 |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.