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

In LibreOffice Calc (3.6.2.2), 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.

Pseudocode:

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