Averages in a Column with Totals for Headers

[helpexcel]

Hi - I have a dynamic spreadsheet with data in columns A:K starting at row 10. I want to put averages of columns A:K in column L, expect if the value in row A is "Small", "Medium", "Large". For those rows i want to total columns A:K in column L. I want avoid using a really long =if formula. thanks!

 

[tyija1995]

Hey how about this:

=IF(OR(A10="small",A10="medium",A10="large"),SUM(A10:K10),AVERAGE(A10:K10))

 

[helpexcel]

Thanks! sometimes I can't see the forrest through the trees. Any ideas if i want to change it to sum the rows between each of those labels?