Software

General discussion

Locked

Linked cells returning 0s vs empty cells

By wordworker ·
I have a client who has a "data" sheet and a "results" sheet. He links (refers to) cells in the data sheet to selectively pull data into the results sheet. In the results sheet, he does some COUNT and COUNTIF calculations.
Problem: When a cell in the data sheet is blank, he wants to "pull" a blank into the results sheet, but he's getting zeroes. Tried suppressing display of zeroes in both sheets, didn't help. Any suggestions?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Linked cells returning 0s ...

Use an If statement.
=If(Sheet1!A1="","",Sheet1!A1)

Collapse -

by DKlippert In reply to

Or, to look more professional:
=If(ISBLANK(Sheet1!A1),"",Sheet1!A1)

Collapse -

by DKlippert In reply to

See:
Cell Counting Techniques
http://tinyurl.com/x9nh
by John Walkenbach


=COUNT(Range)-COUNTIF(Range,0)

=COUNTIF(Range, ">0")

Collapse -

by wordworker In reply to

Poster rated this answer.

Collapse -

by wordworker In reply to Linked cells returning 0s ...

Hey Thanks DKlippert! I knew I could count on you. I've forwarded your suggestions to the user. He's kind of a cowboy formula writer, so I'm hoping he'll follow your suggestions and get the result he wants. I'm waiting for confirmation from him before I award ze points! -Jeff

Collapse -

by wordworker In reply to Linked cells returning 0s ...

This question was closed by the author

Related Discussions

Related Forums