LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default COUNTIF, criteria is cell-to-cell comparison

Hi All,

Here's my problem in a nutshell. I have rows of values, and I want to count
the number of cells where Row A's value is less than Row B's value. (It's
basically a match spreadsheet calculating number of holes won per player in
match format.) Cumulative difference of the row ranges won't help. Any
ideas? I don't think COUNTIF will support this, but I'm sure there's got to
be a way.

Here's a visual:

Scores Holes Won
Tiger Woods 5 3 4 5 4 2 4 4 4 X

Rory Sabbatini 4 4 4 5 3 4 4 3 4 X

Thanks,

Jamie
 
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
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets Doctorjones_md Excel Discussion (Misc queries) 7 June 8th 07 09:32 PM
Countif criteria in another cell rclough Excel Discussion (Misc queries) 3 February 13th 07 10:24 PM
COUNTIF, dates and blank cell criteria luvthavodka Excel Discussion (Misc queries) 6 June 1st 06 09:48 PM
Two cell Comparison with three different Criteria [email protected] Excel Worksheet Functions 8 December 28th 05 03:33 PM
Could the "Criteria" in COUNTIF function be a cell reference? JohnSheenWSN Excel Worksheet Functions 2 June 16th 05 08:07 PM


All times are GMT +1. The time now is 11:32 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"