Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|