How To Add Cells Selected by Another Cell in the Row?

[abrogard]

I have a column of values.

Then there’s two more columns: One for Assets and one for Liabilities.

There’s just a ‘Y’ in the respective column to show where that value in that row belongs.
Is it an asset or a liability? Look see where the ‘Y’ is. In assets col or liability col.

Easy enough.

How can I total the values for the assets, selecting the cells from the column of associated ‘Y’ entries?

I sort of need an IF statement inside a Sum() or something don’t I?

EDIT. I should edit or I should ‘reply’ ?

I have a symbol in that box now. A tick. ✓

I cannot get sumif to work with it. I have tried =sumif(b43:b46,✓,a43:a46) with the tick in quotation marks, too, but it won’t work either way. It gives me an err 501 and immediately truncates the formula.

Should it work with symbols?

[robleyd]

SUMIF, SUMIFS or Pivot tables are all possible solutions.

[robleyd]

I would design the spreadsheet with a single column for Status - the value of which could be Assets or Liabilities. Calculations would be easier,; you could use a dropdown to enter the values and you could also use a pivot table to summarise.

[abrogard]

sounds a bit complicated to me… at my stage of development… but thanks.

[anon73440385]

Hello,

please see the attached example file (it also works using “✓”)

Asset-and-Liabilities-SUMIF.ods

Created and tested using LibreOffice:

  Version: 6.3.2.2, Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
  CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5;
  Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.

[abrogard]

Thanks for this.