Disclaimer: I have no idea what I'm doing.
In LibreOffice Calc (22.214.171.124), 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
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.
If B:x is n: add G:x to SUM
Attempt (where N=1):
=SUM(IF(B2:B529, "1"), G2:G529)
PS: For the sake of semantics, assume that LibreOffice Calc == Microsoft Excel