Thread: syntax for countif when cells fall within a numerical range
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default syntax for countif when cells fall within a numerical range
"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.

One way, via sumproduct, eg:
=SUMPRODUCT((A2:A10=41)*(A2:A10<=50))
Adapt the range to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote