Please accept my apologies, I'm unsure what the forum policy is when you've posted a question but not been able to find a solution, so this is a repost of this problem. The original can be found here:
http://www.excelforum.com/excel-form...umproduct.html
Basically nflsales came up with a really neat SUMPRODUCT MMULT formula to solve a problem (see link above)
and now I need to adjust this formula to allow me to display the variance as a percentage. See column AA in the attached, this gives me the variance based on the current month as defined by the SUM of the total actual column equalling zero, but for the life of me I can not figure out how to convert this into a percentage.
I wondered if any geniuses out there could assist as I've been trying to figure this out for days and am no closer... The expected results appear in column AD, but need to use an adaptation of nflsales's SUMPRODUCT to obtain the result.
Many thanks in advance for any help.
Bookmarks