Discussion Locked

Linked cells returning 0s vs empty cells

0 helpful

6 replies

by wordworker Dec 1, 2003 last reply Dec 3, 2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

6 replies

by dklippert Dec 1, 2003

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

by dklippert Dec 1, 2003

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

by dklippert Dec 1, 2003

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

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

=COUNTIF(Range, ">0")

by wordworker Dec 3, 2003

Poster rated this answer.

by wordworker Dec 2, 2003

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

by wordworker Dec 3, 2003

This question was closed by the author

This discussion is closed to new replies.

6 replies

Trending Software posts

Network Printer Works for Everyone Except Me

Can I Print Emails Directly from a PST File

Is There any Reverse Video Search Tool

Useful software Tip or Shortcut

Hello everyone