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.

6 total posts (Page 1 of 1)  
| 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

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums