SOS! how do I write a customized function to do multiple-value lookupin Excel 2007?
in [Charts]
|
Prev: SOS! how do I write a customized function to do multiple-value lookup in Excel 2007?
Next: m2 behinde a number and I want to sum
From: teylyn on 1 Dec 2009 03:49 You posted in the Charting newsgroup. You may get better response in the Programming newsgroup!! LunaMoon;573052 Wrote: > I have two regions in exact same places of sheet 1 and sheet 2, > I want to find all cells in the region in sheet 1, with cell > content equal to 0, > and then add the numbers at the corresponding locations in the region > in sheet 2 up. > For example, let's say in the region in sheet 1, > there are multiple locations where the cell content = 0: > A1, > B3, > C4, > D2, > etc... > I would like to obtain sum(sheet2!A1, sheet2!B3, sheet2!C4, sheet2! > D2), etc. > How do I do that? > I want to write a user customized function for that: The regions in > sheet1 and sheet2 are fixed to be D7 to Z20. > So the first step is to find all cells in sheet1 in D7 to Z20 with > values=0, and then add up all such cells in sheet2... > How to do that? I am a green hand in using Excel/VBA... > Thanks a lot! -- teylyn Telyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com) ------------------------------------------------------------------------ teylyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=983 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=158325 [url="http://www.thecodecage.com"]Microsoft Office Help[/url] |