Results 1 to 5 of 5

Counting cells and ignoring references

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2008
    Location
    Littleton, CO
    Posts
    12

    Thumbs up Counting cells and ignoring references

    Hello,

    I have a range of cells (B6:M6) and I want to count how many have data. My problem is that all of the cells reference cells on another worksheet. Every cell starts out like =Bethlehem!B6. I want to ignore cells that have a reference in it when I count. I know how to do it if you want to ignore these cells as follows: =countif(b6:m6,"<> 0"). Those cell references return a 0 if they have no data in them. However, a user might actually enter a 0 in the referenced cell and I need to count that one. The above formula would exclude it. Any suggestions?

    Thank you very much,

    Dave
    Last edited by coachdave; 08-21-2009 at 11:19 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1