Amount Donated vs. Pledged [Excel Formula Homework]
We have some home work folks! Today, lets test your Excel formula skills by giving some data related to a fund.
You manage a fund for a non-profit. You have donors who pledge certain amount at the start of the year. As you go thru the year, the donors donate money to your fund. At the end of the year, you have a table like this:
And you need to summarize the fund’s performance by calculating all these statistics.
Download the homework file:
Click here to download the homework file. Write formulas in all blue boxes so that the values are calculated properly.
The correct answers are shown below:
Post your Answers using Comments
Once you finish calculating the summary values, please share your approach (and formulas) using comments. Go!
Download the solution file:
If you like to test your Excel skills then, checkout some of these homework problems:
- Calculate sum of digits in a number using Array formulas
- Find average of closest 2 numbers
- When does Thanksgiving day occur on same day again?
- Show zebra lines when value changes
- … More homework & Excel challenges
Special thanks to David, who emailed me this problem a few weeks ago.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« How to create a Win-Loss Chart in Excel? [Tutorial & Template]
|Comparing Lists of Values in Excel using Array Formulas »