Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count a range of cells using an IF
Hey everyone,
Excel 2000 I have a range of cells like so (each number is in it's own cell) 50 20 30 60 90 30 The FIRST cell (in this case, "50") is the 'recommended value'. What I want to do is create a function that looks at all the other 'variable' cells (20, 30, 60....) as one whole range and checks to see if any one of them are less than the recommended value of 50. If so, I want to see a count of how many 'variables' were less than 50. So in this example, I would like to see the answer of "3", because there are three variables in that range of cells that are less than 50. Hope that makes sense. Assuming it would be some kind of IF / COUNTIF, but can't figure out how to do it. Thanks so much! J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to count cells in a range with a given backcolor? | Excel Worksheet Functions | |||
Count Certain Cells in Specified Range | Excel Worksheet Functions | |||
count cells in a range | Excel Worksheet Functions | |||
Count occurances in range of cells | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |