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
---
|