I'm working in a sales summary file, and I'm using the following formula:
{=(SUMPRODUCT(TRANSPOSE('2013 Market Matrix'!$U$17:$BJ$17),'Top 40C by Month vs PY'!E$8:E$49))}
The purpose of this is to take sales dollars from customers and run that against a series of percentages to determine sales dollars by market. I had an issue with this about a month ago, and I ended up just recreating the sheet that the formula is used in. That was the only way I could get it to work.
I just updated the 'Top 40C by Month vs PY'!E$8:E$49 numbers, and everything in the file updated except for this one table. I've verified the rest of the data, and everything looks fine so far, but I can't figure out what's preventing the cells using this formula from updating.
Please help!
{=(SUMPRODUCT(TRANSPOSE('2013 Market Matrix'!$U$17:$BJ$17),'Top 40C by Month vs PY'!E$8:E$49))}
The purpose of this is to take sales dollars from customers and run that against a series of percentages to determine sales dollars by market. I had an issue with this about a month ago, and I ended up just recreating the sheet that the formula is used in. That was the only way I could get it to work.
I just updated the 'Top 40C by Month vs PY'!E$8:E$49 numbers, and everything in the file updated except for this one table. I've verified the rest of the data, and everything looks fine so far, but I can't figure out what's preventing the cells using this formula from updating.
Please help!