Ask Your Question

Revision history [back]

Sumif using multiple partial matches

Hi All,

Coming from a low-medium level skill level with Excel, trying to get my head around the differences with LibreOffice Version: 6.0.4.2 (please be gentle).

Likely a better way of doing this, however I have been maintaining a basic income/expense spreadsheet where I take ledger style dumps from multiple sources and then use an array containing key words/phrases to categorize entries. Structure of the formula in Excel is as follows;

=SUM(SUMIFS(sum_range,criteria_range,{"*Transport*","*Courier*"}))

Essentially any entry with a description containing Transport of Courier would have the dollar amount of that entry added to the Transit costs category in my main sheet.

Have tried this in LibreOffice and I cannot seem to get it to work. I read something about Arrays not being able to be nested. If this is the case, what would be the best way to sum the numbers in one column when a partial match on multiple criteria is found in another column?

Really appreciate the assistance.

Sumif using multiple partial matches

Hi All,

Coming from a low-medium level skill level with Excel, trying to get my head around the differences with LibreOffice Version: 6.0.4.2 (please be gentle).

Likely a better way of doing this, however I have been maintaining a basic income/expense spreadsheet where I take ledger style dumps from multiple sources and then use an array containing key words/phrases to categorize entries. Structure of the formula in Excel is as follows;

=SUM(SUMIFS(sum_range,criteria_range,{"*Transport*","*Courier*"}))

Essentially any entry with a description containing Transport of Courier would have the dollar amount of that entry added to the Transit costs category in my main sheet.

Have tried this in LibreOffice and I cannot seem to get it to work. I read something about Arrays not being able to be nested. If this is the case, what would be the best way to sum the numbers in one column when a partial match on multiple criteria is found in another column?

Really appreciate the assistance.