We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Count merged cells in calc [closed]

asked 2012-06-09 20:50:53 +0200

Holmes gravatar image

updated 2015-10-16 18:51:33 +0200

Alex Kemp gravatar image

I am using a simple time tracker for tasks in calc (libreoffice The task names are entered from a list, and the cells are merged for continuous durations. In order to calculate the total time per task, I need to know a count of rows spanned by each task. A simple COUNTIF() would only return the number of occurrences of the task string, whereas I am looking for a metric that counts the number of cells in the merged ones.

I searched a lot, but cannot figure out how to implement this. I know it is not advised to use merged cells for calculations etc. but having to enter text for every entry makes it more tedious.

Thank you for any input!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 18:51:43.696882

1 Answer

Sort by » oldest newest most voted

answered 2012-06-12 10:51:41 +0200

Holmes gravatar image

Got some interesting responses here : http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=54366

And a solution that fits my requirement.

edit flag offensive delete link more

Question Tools


Asked: 2012-06-09 20:50:53 +0200

Seen: 1,272 times

Last updated: Jun 12 '12