Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 13th 05, 08:40 PM
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.

  #2   Report Post  
Old November 13th 05, 09:14 PM
Bob Phillips
 
Posts: n/a
Default can you use countif function for noncontiguous cells

Not countif, but you can do it

=SUMPRODUCT(--(A1:M1="value),--(MOD(COLUMN(A1:M1),2)=0)

which will count B, D, etc. if they equal the required value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rutledbr" wrote in message
...
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.



  #3   Report Post  
Old November 13th 05, 09:15 PM
Peo Sjoblom
 
Posts: n/a
Default can you use countif function for noncontiguous cells

One way

=SUMPRODUCT((MOD(COLUMN(A2:O2),2)=1)*(A2:O2="A"))

will count A in A2:O2 in A, C, E etc

--
Regards,

Peo Sjoblom

(No private emails please)


"rutledbr" wrote in message
...
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.




Reply
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:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017