Sum and Avg on the same subtotal line

[Mark]

I am working on a worksheet where I have 4 columns of
numbers. The customer wants columns 1 & 4 averaged and
columns 2 & 3 summed. They want these all on one line of
the sheet.

Can this be done?

 

[Bernard V Liengme]

Hi Mark,
Lets say the data is in A1100
Do you want
(1) an average for Columns A and B combined. Use =AVERAGE(A1:B100) in cell
A101 (or anywhere you wish), OR
(2) one average for A and another for B. Use =AVERAGE(A1:A100) in A101 (or
elsewhere) and =AVERAGE(B1:B100) next to it.
Do likewise for SUM

Have I missed something in this question?
Bernard

 

[Peo Sjoblom]

Not sure what you mean?

Do you mean

=AVERAGE(A1:A100,D1100)

and

=SUM(B1:C100)

where A and D are the 1st and 4th columns and B and C the 2nd and 3rd..

If not post back..