Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Disclaimer: I have no idea what I'm doing.

In LibreOffice Calc (, I'm trying to SUM all of the values in G:x (where range is G2:G529), where B:x is equal to a given number N.

The data set that I'm working with has been derived from a list of strings - the goal is to: find all strings of length N where N is hard-coded into the query string.

Data (snippet)


If B:x is n: add G:x to SUM

Attempt (where N=1):

=SUM(IF(B2:B529, "1"), G2:G529)

Any suggestions?

PS: For the sake of semantics, assume that LibreOffice Calc == Microsoft Excel

share|improve this question
up vote 3 down vote accepted

In Excel you can use SUMIF function like this


The same formula should work in Libre Office

share|improve this answer
Perfect, thank you. I was so close. – Tyler Feb 24 '13 at 23:19
To confirm: it does, indeed, work a treat in LibO Calc. Just what I needed, too. – Davïd Dec 27 '13 at 13:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .