View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Count If Function

Do you mean =25 and <=40 ?

Try this:

=COUNTIF(A1:A20,"=25")-COUNTIF(A1:A20,"40")


--
Biff
Microsoft Excel MVP


"benny" wrote in message
...
Is there a way to use the Count if function to count if a value is between
25
and 40?

Using Excel 2003