LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
talderman
 
Posts: n/a
Default I want to know how many times 2 corresponding cells meet a conditi

I have 2 columns of numbers I would like to know how many times the value in
column A meets a certain value in column B.
ex)
column A column B
row1 1 2
row2 1 2
row3 1 2

How many times does the value 1 in column A match the corrspond value of 2
in column B. For clarity in this example it occurs 3 times?
--
Tim
 
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
Fill cells with times annep Excel Worksheet Functions 2 April 2nd 06 11:16 PM
Excel 2003, which formula will count the cells that meet 2 conditi lawoman35 Excel Worksheet Functions 4 March 23rd 06 09:27 PM
counting cells in a data range that meet 3 specific conditions bekah7 Excel Discussion (Misc queries) 3 October 1st 05 06:21 AM
how do i protect cells in a shared worksheet Debi Excel Discussion (Misc queries) 3 September 30th 05 11:15 PM
Can you limit the amount of times a calc is performed on certain cells n_davies Excel Discussion (Misc queries) 1 January 24th 05 10:43 PM


All times are GMT +1. The time now is 07:12 PM.

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

About Us

"It's about Microsoft Excel"