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?
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?
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?
>
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
--
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?
>
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?
>
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?
> >
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?
> >
Try:
=SUM(COUNTIF(A1:A20,{">320",">345"})*{1,-1})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks