Thread: syntax for countif when cells fall within a numerical range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sb1920alk sb1920alk is offline
external usenet poster
  
Posts: 100
Default syntax for countif when cells fall within a numerical range
Countif can only be used with one criteria.

Use Sumproduct instead. For example, if your list is in A1:A100, you could
use =SUMPRODUCT(--(A1:A100=41),--(A1:A100<=50))

"Tom L" wrote:

I have a column of numerical data, for which I need frequency counts within
certain ranges. E.G. If a cell value is = 41 AND <= 50, I want to count
that cell as one. I can't figure out the syntax.
Reply With QuoteReply With Quote