A
annieandtika
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?
value of greater than 320 and less than 345?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
You can use the SUMPRODUCT() function.
G
Gary''s Student
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:A20>320),--(A1:A20<345)) would yield 7
300
382
315
400
350
383
338
325
340
365
323
310
345
341
357
399
386
325
342
376
then =SUMPRODUCT(--(A1:A20>320),--(A1:A20<345)) would yield 7
B
bpeltzer
You could also use two countif functions:
=countif(A:A,">320")-countif(A:A,">=345").
The first countif tallies up those entries that are over 320; the second
backs out those at least 345, leaving only those between 320 and 345.
=countif(A:A,">320")-countif(A:A,">=345").
The first countif tallies up those entries that are over 320; the second
backs out those at least 345, leaving only those between 320 and 345.
A
annieandtika
Hi - thank you so much for replying but I still can't seem to make it work.
Excel keeps correcting the formula.
Excel keeps correcting the formula.
A
annieandtika
Hi = Thank you so much for replying but I still can't make it work - it
doesn't give me the right response.
doesn't give me the right response.
V
vane0326
Try:
=SUM(COUNTIF(A1:A20,{">320",">345"})*{1,-1})
=SUM(COUNTIF(A1:A20,{">320",">345"})*{1,-1})