Add Values in Column B, if Column A has a certain value.

DLABS Consulting · 08/10/18

Hello,

Thanks in advance for any help provided.

I date values in column A, the day a quote is signed. I have dollar values in column B, the amount of the quote.

I want to total of the amounts in Column B that have an associated signed date. Basically, the total of value of quotes "unsigned." Pleas help, Smartsheet formulas are not as straight forward as Excel.

Andrée Starå · 08/10/18

Hi,

Try this

Signed:

=SUM(CHILDREN(Amount1)) - SUMIF(CHILDREN(Date1); ""; CHILDREN(Amount1))

Unsigned:

=SUMIF(CHILDREN(Date1); ""; CHILDREN(Amount1))

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Add Values in Column B, if Column A has a certain value.

Comments

Categories