Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of rooms
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of rooms
I'm guessing that you want to count *unique* room numbers.
=SUMPRODUCT(--(FREQUENCY(A2:A10,A2:A10)0)) Result = 2 -- Biff Microsoft Excel MVP "salaam" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of cells that match name AND number | Excel Worksheet Functions | |||
How to sort usage of rented rooms on monthly basis? | Charts and Charting in Excel | |||
rooms checklist | Excel Worksheet Functions | |||
set up schedule of meeting space availability, rooms/ times | Excel Discussion (Misc queries) | |||
a simple way to set up spreadsheet for conference rooms reservatio | New Users to Excel |