A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Counting empty cells within a range of cells



 
 
Thread Tools Display Modes
  #1  
Old April 7th, 2005, 12:47 AM
Rosehill - ExcelForums.com
external usenet poster
 
Posts: n/a
Default Counting empty cells within a range of cells

A sheet can have a variable range of adjacent cells each containing
the value =1
The range defines the perimeter of, or surrounds a group of empty
cells however outside the perimeter, the remaining cells on the sheet
are empty as well.

The task is to count the empty cells that are surrounded by the
perimeter of 1’s:

To do this manually, I use the @countif (range=0) function however it
requires that I go into the worksheet and select the range manually.

I would like to do this by formula or macro.

The knowns a
1) The location of the start/end cell of the range
2) That the next cell in the range will be above, below, left or
right of its neighbour but we never know which.
3) I think to define the range, I need to to search for the location
of all cells having the value of 1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Applying formula to only NON-EMPTY cells in range Tasi General Discussion 5 March 29th, 2005 10:48 PM
how do I deselect cells within a range of cells Alaskaptj General Discussion 6 October 20th, 2004 10:34 PM
Please help! Displaying only rows with empty cells in a numeric field using Advanced Filter. Thanks JOCA New Users 1 June 5th, 2004 02:37 AM
is there a formula that can count a range of cells with text? Frank Kabel Worksheet Functions 0 March 11th, 2004 08:04 PM
CountIf - Counting cells between a range of numbers Matt Worksheet Functions 1 December 17th, 2003 12:41 AM


All times are GMT +1. The time now is 04:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.