counts between two values

[smithrd6]

I have this forumula for capturing counts which are less than a number:

{=SUM((tbl42Ques!D2:D200="Released to Manufacturing")*(tbl42Ques!A2:A200<16))}

I am wanting to capture counts which are between two numbers, for instance, <16 and >10

 

[Gerald Higgins]

Try this (my example uses simplified cell references - adapt as required)

=sumproduct(d2:d200,--(a2:a200<16),--(a2:a200>10))

 

[Norie]

Perhaps something like this.

=SUMPRODUCT(--(tbl42Ques!D2:D200="Released to Manufacturing"), --(tbl42Ques!A2:A200>10), --(tbl42Ques!A2:A200<16))

 

[Gerald Higgins]

There's a difference between these two formulas.

Mine is summing up numeric values in column D, for rows where the entry in column A matches the criteria.

Norie's version (I think) is counting those values (which looks like it may be closer to what was requested in the OP).

 

[Norie]

Gerald

Good spot - think I missed the SUM part, though the OP did mention a count.