Sum row by row using CSE

[TheGallows32]

Hi everyone! In a bit of a pickle :S

Let's say I have 10 rows of numerical data across 10 columns, and I'd like to sum the numbers across each row.
In the end I would have 10 sums (one for each row) that I could then Average.

Simple enough if you're dealing with a static worksheet, but in my workbook I'm dynamically grabbing different samples of data using drop-down list input fields and the OFFSET, INDIRECT, and VLOOKUP functions.

I know how to use CSE functions to do things like =SUM(C2:C11*E2:E11)...
I'm wondering if I can use a similar technique to sum each individual row, and then average the sums.

Thanks!
-J

 

[Jonmo1]

Welcome to the board.

Wouldn't that be
=SUM(A1:J10)/10
?

 

[footoo]

Maybe :
=SUM(A1:C10)/(ROW(C10)-ROW(A1)+1)

 

[TheGallows32]

Welcome to the board.

Wouldn't that be
=SUM(A1:J10)/10
?

wow you're right; I was totally overthinking it. Thank you!

 

[Jonmo1]

You're welcome.

If the range does change (but you at least know what the range is), you could use the ROWS function to count the rows instead of having to hard code the 10

=SUM(A1:J10)/ROWS(A1:J10)

 

[TheGallows32]

Welcome to the board.

Wouldn't that be
=SUM(A1:J10)/10
?

This works, but if I need to also calculate STANDARD DEVIATION then I'm back in the same pickle

 

[TheGallows32]

This works, but if I need to also calculate STANDARD DEVIATION then I'm back in the same pickle

Is it possible to have a single-cell CSE formula that receives varying ranges based on user input?