LinkBack URL
About LinkBacks
I have three columns of numbers (B1:B10, C1:C8, D1:D15). I would like to create a formula to obtain the overall average of all the numbers in the three columns. I am not having luck accomplishing this. Thanks!
I have three columns of numbers (B1:B10, C1:C8, D1:D15). I would like to create a formula to obtain the overall average of all the numbers in the three columns. I am not having luck accomplishing this. Thanks!
=(sum(b1:b10)+sum(c1:c8)+sum(d1:d15))/33
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Simply..
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
Is there an way to use one of the "Average" formulas and have it auto-calculate as the numbers in the columns/rows grow?
You could just use
=AVERAGE(B1:D100)
or any other large range, as Average considers only non-blnak cells
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks