For example if A1 thru A20 contained:
300
382
315
400
350
383
338
325
340
365
323
310
345
341
357
399
386
325
342
376
then =SUMPRODUCT(--(A1:A20320),--(A1:A20<345)) would yield 7
--
Gary's Student


"annieandtika" wrote:

What formula do I use to count the numbers of cells in a range which return a
value of greater than 320 and less than 345?