View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] carmen@unitedbenefitadvisors.com is offline
external usenet poster
 
Posts: 4
Default counting the number of rooms

On May 5, 6:06*pm, salaam wrote:
room no name
125 * * shiyam
143 * * jabui
125 * * slim

total No. of room ?

i have lot of rooms like this but i just want calculate number of rooms.


Sorry if I'm not understanding your question correctly, but I think a
COUNT function should do this. =COUNT(A2:A4) will tell you that the
table above has 3 rooms.