SumProduct Function for Allocations

This is blog already caters to a very niche group of people, but this post is probably for a niche of the niche…niche2. I’m kind of an Excel nerd. My primary language, the first tool I go to for any problem is Excel. When other people want to send out mass emails, they sign up for Constant Contact or Mail Chimp. I made a spreadsheet to do this.

I had kind of dismissed the SUMPRODUCT function as pretty much irrelevant and useless until one day while helping a church with a Narrative Budget. I was trying to allocate budget lines based on certain percentages in adjacent columns using my regular method when it hit me: Is this the job SUMPRODUCT was intended for? It worked beautifully so that’s why I’m sharing it with you. It saves a lot of time and reduces the risk of errors.


Useful Links

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s