Excel Sumproduct + Excel 2003

Joined
May 14, 2012
Messages
21
Reaction score
0
somehow, the problem is here again.. can u plz help me out..? i eneterd the formula (as mentioned) in the cell as an array, dragged it down and filled the series. but again its showing me the same values as the first one (ie all r same values, as per year 1993). what to do?
 
Joined
May 14, 2012
Messages
21
Reaction score
0
and to get the correct result , i have to select eacj cell, press F2 and then ctrl+shift+enter. any easy/direct way to do it?
 
Joined
Mar 20, 2012
Messages
764
Reaction score
4
It sounds like you have your calculation mode set to Manual. Go to Tools | Options, I forget the tab, but look for Calculation Mode and change it to Automatic. You can also press F9 to refresh formulas on the page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top