| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SOS! how do I write a customized function to do multiple-value lookupin Excel 2007?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SOS! how do I write a customized function to do multiple-value lookup in Excel 2007?
see your other post
-- Biff Microsoft Excel MVP "LunaMoon" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Function INTO Customized Toolbar | Excel Discussion (Misc queries) | |||
| How do I add a customized button with macro in Excel 2007 for acce | Setting up and Configuration of Excel | |||
| Is there a write-multi-cell-at-once function in VBS for Excel? | Excel Discussion (Misc queries) | |||
| How do I create a customized toolbar button? Excell 2007 | Excel Discussion (Misc queries) | |||
| Customized function (in cell) does not refresh value :o( | Excel Discussion (Misc queries) | |||
Linear Mode
