Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
annieandtika
 
Posts: n/a
Default count number of cells in range showing between 320 and 345

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?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default count number of cells in range showing between 320 and 345

You can use the SUMPRODUCT() function.
--
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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default count number of cells in range showing between 320 and 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: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?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default count number of cells in range showing between 320 and 345

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.

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
annieandtika
 
Posts: n/a
Default count number of cells in range showing 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.

"Gary''s Student" wrote:

You can use the SUMPRODUCT() function.
--
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?



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
annieandtika
 
Posts: n/a
Default count number of cells in range showing between 320 and 345

Hi = Thank you so much for replying but I still can't make it work - it
doesn't give me the right response.

"bpeltzer" wrote:

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.

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

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vane0326
 
Posts: n/a
Default count number of cells in range showing between 320 and 345


Try:


=SUM(COUNTIF(A1:A20,{"320","345"})*{1,-1})


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=555212

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"