Countif function

[baranovitch]

Hi, I would like the Total Rooms used per day column (see link) to display the total numbers of rooms in use that day, where the numbers currently in the table indicate the book-in date and total days booked.

Is this possible to do?


http://img517.imageshack.us/img517/6...countifgi7.jpg

Thanks for any help

[tuph]

in cell P6, try =COUNTIF(B6:O6,">0")

If this works, copy the formula down the column.