View Single Post
  #1   Report Post  
Daniell
 
Posts: n/a
Default Sum and Count Function

Is there a function that will count and Average colums at the same time. I
have a spread sheet that has 2500 rows with 20 colums. Out of the 20 colums
two of these are unique and I need to count and avergae by those columes and
put them on a single line. I understand that the SUBTOTAL function will do
these functions but on seperate lines.