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 answers

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    If Mike-31's formula seems too complex, you can simply use =COUNTA(A1:A1000)
    --
    Retirement is great! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    2
    1. flo
       
      super practical, thanks
      0
  2. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    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
    1. 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