I am curious if anyone can help me out. I am trying to create both an
average and a sum formula that will limit or exclude certain fields.
Here is an example of what I'm working with:
Day1: 25
Day2: 20
Day3: 20
Day4: 25
Day5: 25
Weekly Total: 115
Day1: 15
Day2: 20
Day3: 30
Day4: 35
Day5: 25
Weekly Total: 125
Daily average= ?
Daily Total= ?
Is there any way to run an average excluding the weekly total fields
either by color or any other way. There is a SUM formula in the weekly
total field, can formula fields be excluded? The same for the average
of the daily numbers?
Thanks for any help you can provide.
Todd
--
dagger
------------------------------------------------------------------------
dagger's Profile:
http://www.excelforum.com/member.php...o&userid=24996
View this thread:
http://www.excelforum.com/showthread...hreadid=385228