Results 1 to 6 of 6

Automatically include adjacent cells

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

01-16-2017, 11:51 AM #3
Tony Valko

View Profile

View Forum Posts
Forum Expert

Join Date

12-31-2011

Location

Pittsburgh

MS-Off Ver

2002, 2007:2013

Posts

18,890
Re: Automatically include adjacent cells

Just expand the ranges in the formula...

=COUNTA(A1:A100)-COUNTIF(A1:A100;"-")

Biff
Microsoft MVP Excel
Keep It Simple Stupid

Let's Go Pens. We Want The Cup.
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

I need to create a dropdown list but want to automatically include adjacent colums

By caremeals in forum Excel Formulas & Functions

Replies: 1
Last Post: 05-07-2016, 01:56 PM
Automatically delete cells based on adjacent cell color

By chromecarz00 in forum Excel General

Replies: 1
Last Post: 04-17-2014, 07:05 PM
Automatically updating adjacent cells based on drop-down list selection even if you change

By anonDymous in forum Excel General

Replies: 1
Last Post: 04-12-2013, 06:27 PM
Automatically Fill Adjacent Cells Based On Input Data

By maxraph in forum Excel Formulas & Functions

Replies: 1
Last Post: 09-26-2012, 01:04 PM
Formula needed to fetch data from different worksheets and include adjacent cells

By topgearmedia in forum Excel General

Replies: 1
Last Post: 12-22-2010, 09:08 AM
[SOLVED] how do i add in numbers automatically based on adjacent cells cont

By lemskibar in forum Excel General

Replies: 2
Last Post: 12-22-2005, 01:30 PM

Tags for this Thread

adjacent cell

Bookmarks

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 05:13 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1