Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF, criteria is cell-to-cell comparison
For Tiger (scores in the range B2:J2):
=SUMPRODUCT(--(B2:J2<B4:J4)) For Rory (scores in the range B4:J4): =SUMPRODUCT(--(B4:J4<B2:J2)) Biff "Jamie W" <Jamie wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF, criteria is cell-to-cell comparison
Much appreciated, I JUST came across the SUMPRODUCT function in another post,
thanks! :) Jamie "T. Valko" wrote: For Tiger (scores in the range B2:J2): =SUMPRODUCT(--(B2:J2<B4:J4)) For Rory (scores in the range B4:J4): =SUMPRODUCT(--(B4:J4<B2:J2)) Biff "Jamie W" <Jamie wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF, criteria is cell-to-cell comparison
You're welcome!
Biff "Jamie W" wrote in message ... Much appreciated, I JUST came across the SUMPRODUCT function in another post, thanks! :) Jamie "T. Valko" wrote: For Tiger (scores in the range B2:J2): =SUMPRODUCT(--(B2:J2<B4:J4)) For Rory (scores in the range B4:J4): =SUMPRODUCT(--(B4:J4<B2:J2)) Biff "Jamie W" <Jamie wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
Countif criteria in another cell | Excel Discussion (Misc queries) | |||
COUNTIF, dates and blank cell criteria | Excel Discussion (Misc queries) | |||
Two cell Comparison with three different Criteria | Excel Worksheet Functions | |||
Could the "Criteria" in COUNTIF function be a cell reference? | Excel Worksheet Functions |