Thread: Count If Function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Count If Function
Assuming you are including 25 and 40

=SUM(COUNTIF(A1:A100,{"=25","40"})*{1,-1})


"benny" wrote:

Is there a way to use the Count if function to count if a value is between 25
and 40?

Using Excel 2003
Reply With QuoteReply With Quote