LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rutledbr
 
Posts: n/a
Default can you use countif function for noncontiguous cells

I am trying to use the countif function to add the appearance of value in
cells that are not adjacent to each other. Specifically I have two cells that
pertain to the same question. For each question I want to compile the
occurence of certain value therefore I want to use the countif function on
every second column.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use TREND function with nonadjacent cells BonesCCS Excel Worksheet Functions 0 August 4th 05 10:59 PM
Conditionial formatting for merged cells, function Len($A$4) CajunWebfoot Excel Worksheet Functions 1 July 28th 05 04:42 PM
multi function cells kellerfro Excel Discussion (Misc queries) 4 June 27th 05 07:34 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
counting cells (COUNTIF) based on two or more criteria Tricia S. Excel Worksheet Functions 10 March 17th 05 02:17 PM


All times are GMT +1. The time now is 08:44 PM.

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

About Us

"It's about Microsoft Excel"