Hi guys i'm trying to figure out a way to automatically calculate my goal completions each week which i track using excel and google docs.
Which looks like this: http://grab.by/LYwI
I want to calculate the success rate automatically in column B3. Which is basically the number of times that goal was completed divided by the number of days.
So in that example the output would be 6%.
I can manually do this, but was wondering if there is way to automate this. E.g. everytime i add a new day, it just calculates the success rate automatically.
I have attached the file with both the input and output (what i'm looking to achieve).
Thankyou.
Bookmarks