| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count a range of cells using an IF
Max,
As A1 can never be less than A1 then it will not be included in the count, so you can include it in the range as per your first post. Pete On Jul 31, 12:01*am, Max wrote: Errata, range should exclude recommended value in A1, viz: In F1: =COUNTIF(B1:E1,"<"&A1) -- Max Singaporehttp://savefile.com/projects/236895 Downloads:16,400 Files:356 Subscribers:53 xdemechanik --- |
| 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 | |||
Threaded Mode
