View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default countif(range, between value 1 and value 2)

=Countif(D1:D150,"=86.81%")-Countif(D1:D150,"86.83%")

OR

=Sumproduct((D1:D150=86.81%)*(D1:D150<=86.83%))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gaurav" wrote in message
...
How do I say this?

Count the values in D1:D150 that are between 86.81% and 86.83%?

Thanks for reading this :)