Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarizing Data
Is there a way I can have a macro look at a worksheet and look down a certain
column, if the number in that column is x then return the value of a certain column. For example: Summary worksheet macro look at jan 08 worksheet. Then go down column "C" and if they is a 0,1,2,3,4 then grab the amount in column "G" and continue to add the amounts together when at the end of the worksheet place the total in the summary worksheet Column "C" cell 5. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarizing Data
Try this formula (NOT a macro) in C5 of your summary sheet:
=SUMPRODUCT(('Jan 08'!C1:C1000=0)*('Jan 08'!C1:C1000<=5)*('Jan 08'! G1:G1000)) I've assumed 1000 rows - adjust to suit, but you can't use complete column references prior to XL2007. Hope this helps. Pete On Mar 31, 6:34*pm, krc547 wrote: Is there a way I can have a macro look at a worksheet and look down a certain column, if the number in that column is x then return the value of a certain column. For example: Summary worksheet macro look at jan 08 worksheet. Then go down column "C" and if they is a 0,1,2,3,4 then grab the amount in column "G" and continue to add the amounts together when at the end of the worksheet place the total in the summary worksheet Column "C" cell 5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summarizing data | Excel Worksheet Functions | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data based on ID | Excel Worksheet Functions | |||
Summarizing data | Excel Discussion (Misc queries) |