Blank cells in column to return another column value

Eric Goldsmith · 09/28/21

If the cell in {WIP%} column is not blank then return the value of {Tippa Total Value} Column. Were have I gone wrong

=SUMIFS({Tippa Total Value},{WIP%},ISBLANK(@cell))))

David Tutwiler · 09/28/21

You have written a formula to sum values if the value is blank. I think a NOT function will fix this. Something like:

=SUMIFS({Tippa Total Value},{WIP%},NOT(ISBLANK(@cell)))))

Eric Goldsmith · 09/29/21

Hi David

I tried your formula says "Unparsable".

So what do I need to change?

Eric Goldsmith · 09/29/21

Sorry now works my mistake

David Tutwiler · 09/29/21

No problem. Glad it's working.

Answers