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.