Thread: excel: How to set up a formula for a range of numbers ie. 3.5-5..
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default excel: How to set up a formula for a range of numbers ie. 3.5-5..
Hi,

Try this

=countif(range,"=3.5")-countif(range,"5.5")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LadyK974" wrote in message
...
in a spreadsheet i have a range of numbers that needed to be counted ie.
phos levels between 3.5-5.5 I can't find a formula to support this. Can
you
help

Reply With QuoteReply With Quote