ExcelBanter - Count Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count Formula (https://www.excelbanter.com/excel-discussion-misc-queries/218786-count-formula.html)

Janie

Count Formula

I am trying to count the # of instances in a column that the criteria is 13
but <20

I was trying countif(a5:a20,"13",a:5:a:20,"<20") but it's not working. Can
someone help and let me know what I am doing wrong?

John[_22_]

Count Formula

HI Janie
Try this one : =SUMPRODUCT(--(A5:A2013),--(A5:A20<20))
HTH
John
"Janie" wrote in message
...
I am trying to count the # of instances in a column that the criteria is
13
but <20

I was trying countif(a5:a20,"13",a:5:a:20,"<20") but it's not working.
Can
someone help and let me know what I am doing wrong?

All times are GMT +1. The time now is 07:02 PM.