View original (French)

Count guest number on an excel sheet

bbjoebar -  
 flo -
Hello,
I need to count the number of guests on an Excel spreadsheet
it's a list of people that changes regularly, so an automatically updating table could be very practical.
Thank you
Configuration: Windows XP Firefox 3.0.5

2 réponses

Réponse 1 / 2
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
If Mike-31's formula seems too complex, you can simply use =COUNTA(A1:A1000)
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
2
flo
 
super practical, thanks
0
Réponse 2 / 2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 146
 
Hello,

Assuming that in your column from A1 to A1000 you enter a number or a word, place this formula in a cell of your choice

=SUMPRODUCT((LEN(A1:A1000)>0)*1)

A+
0
bbjoebar
 
Thank you Mike-31, it works
can you explain your formula to me just to understand the mechanism, especially the end >0)*1)
0