So I'm a restaurant manager and we track our server PPA's. which is a fancy thing for server check amounts. I want to track each server each week. Here's the thing, each server does not work everyday. So one server might work mon/wed/fri. So i need a formula that averages the amounts only when a value is imputed. But it needs to be already setup so when i put in the days averages it recomputes it again. and if a server works another day like sat it would then average 4 days instead of 3. Is ther anyway to do this?


thanks so much