Thread: Counting data in a range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Counting data in a range
=COUNTIF(C173:E187,"< 225")-COUNTIF(C173:E187,"<200")

--
Gary''s Student - gsnu200794


"Glenn L." wrote:

I need to count the values that are between and equal to 200 and 224 in the
data range of C173:E187. I've tried eveything I could think of and can't get
it right. Please help.
Reply With QuoteReply With Quote