count number of cells in range showing between 320 and 345

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
Hi - thank you so much for replying but I still can't seem to make it work.
Excel keeps correcting the formula.
 
Hi = Thank you so much for replying but I still can't make it work - it
doesn't give me the right response.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
display repeating row information in columns 1
SUM Q 2
subtract one cell from each cell in a range and count instances 2
COUNTIF calculates slow (10000+ records) 6
Remove Civic numbers in Street Address, move to previous blank cell 1
Find and return a value 2
Excel - count if a number falls within an array in a column & add 3

Back
Top