Function Question

TPolanco

I am trying to write a function that adds the numbers entered into one column only if there is a number in another column. Both would be referencing another sheet. For example, column A has the number of dependents a person has. I want to add up the number of dependents entered in column A to display on another sheet, but only add them if there is a number in column B.

Thanks for any and all help!

jmyzk_cloudsmart_jp

Hi @TPolanco

To elaborate on Paul's point, here is a formula that could be used to achieve this in Smartsheet:

=SUMIF(B:B, ISNUMBER(@cell), A:A)

Mine displays on Sheet Summary, not another sheet, but the formula format is the same.

https://app.smartsheet.com/b/publish?EQBCT=813bc566a61d4e0fb33ee867a91521a9

Paul Newcome

This would be a perfect use case for the SUMIFS function:

https://help.smartsheet.com/function/sumifs

.

jmyzk_cloudsmart_jp

Hi @TPolanco

To elaborate on Paul's point, here is a formula that could be used to achieve this in Smartsheet:

=SUMIF(B:B, ISNUMBER(@cell), A:A)

Mine displays on Sheet Summary, not another sheet, but the formula format is the same.

https://app.smartsheet.com/b/publish?EQBCT=813bc566a61d4e0fb33ee867a91521a9

TPolanco

Thanks, that worked perfectly!!

jmyzk_cloudsmart_jp

Happy to help!😁