Hi,
I'm trying to fill down the following formula:
=$B2*SUMPRODUCT($B$2:$B$477;'COV matrix'!B$2:B$477)
While filling down, I want the formula to change from: $B2*SUMPRODUCT($B$2:$B$477;'COV matrix'!B$2:B$477) to $B3*SUMPRODUCT($B$2:$B$477;'COV matrix'!C$2:C$477) etc.
Now, it just stays the same.
Can somebody please help me.
Gilles
Last edited by Gdespont; 02-27-2013 at 12:56 PM.
maybe something like this would work for you:
assuming you are starting in row 2 :
Formula:
Please Login or Register to view this content.
as you drag the formula down, you should be referencing the next column in 'COV matrix' sheet
Hope this helps
Last edited by dredwolf; 02-27-2013 at 12:30 PM. Reason: spelling corrections
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
I don't think it is working.
Maybe it's more easy if i upload a part of the document.
The formula is pasted in sheet "Portfolio maandelijks MAD" from BK2:BK477.
COV.xlsx
Thanks for the help and i'm sorry for my very poor excel skills.
Okay..for some reason, the sumproduct wanted to calculate the column offset calculation as an array...not sure why, but this seems to work..hard to tell with no data in b2 though
Formula:Please Login or Register to view this content.
Hope this helps
Thank you very much!
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks