Hi
Attached file sheets 6, 7 and 8 contains name and break of respective people (Total break is in column O).
I wish to know (may be a formula) how to calculate the average break of everyone.
Thanks.
Hi
Attached file sheets 6, 7 and 8 contains name and break of respective people (Total break is in column O).
I wish to know (may be a formula) how to calculate the average break of everyone.
Thanks.
Hi sushil10s
I use the simplest way to find the solution.
In a new Sheet, or in a sheet that you like(in my example. Sheet!8), use the sum function twice and get your result.
Take a look to the attachment.
Hope to helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks