Thread: Excel formula help please
View Single Post
  #3  
Old 18th August 2005, 11:55 AM
Soho Soho is offline
Member
  
Join Date: Apr 2005
Posts: 3
Default
Twodogs

This one should work for you. To run the formula, make sure you hold down ctrl+shift and then hit enter.

=SUM(IF(A1:H1>0,IF(A1:H1<=3,1,0),0))


Soho
Reply With Quote