G Guest Apr 15, 2004 #1 How do I count the number of cells that contain values within a range, e.g. =countif(A1:A1000, ">=16 and <25) - All the cells that contain a number less than or equal to 16 and
How do I count the number of cells that contain values within a range, e.g. =countif(A1:A1000, ">=16 and <25) - All the cells that contain a number less than or equal to 16 and
F Frank Kabel Apr 15, 2004 #2 Hi try =SUMPRODUCT((A1:A1000>=16)*(A1:A1000<25)) or as alternative syntax =SUMPRODUCT(--(A1:A1000>=16),--(A1:A1000<25))
Hi try =SUMPRODUCT((A1:A1000>=16)*(A1:A1000<25)) or as alternative syntax =SUMPRODUCT(--(A1:A1000>=16),--(A1:A1000<25))
