I have a problem with updating average
Average of daily patients visits is to be daily calculated?
please don't try pivot table
See attached file....
I have a problem with updating average
Average of daily patients visits is to be daily calculated?
please don't try pivot table
See attached file....
Look up how to use =AVERAGEIF() or =AVERGAEIFS()
Your post doesn't give any information at all on what your expected results are, or where you'd like them, so it's difficult to give you a tailor made solution.
BSB
Have a look at the blue cells in the attached.
I'm guessing this is what you mean but as your explanation of the problem was minimal and there's a distinct lack of expected results I have no way of telling...
BSB
I added a few different formulas.
Maybe there are some you can use.
Kind regards,
Piet Bom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks