Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarizing specific data from one worksheet on another
Hello,
I have a fairly simple spreadsheet of population data for a mouse colony. The layout is simplified as follows: Column A: Cage number (0001, 0002, etc) Column B: Females of strain A Column C: Females of strain B Column D: Males of strain A Column E: Males of strain B There is a bit more information being tracked, and many more strains, but this is essentially the layout. I am trying to create a second worksheet that will list information from the main census sheet, but only for breeding cages. This would be any cage with at least one male and one female. I took a straightforward approach =IF(AND(Sum(B2:C2)1,Sum(D2:E2)1),A1) In terms of presentation, however, this leaves a large number of blank rows, and makes finding active breeding cages in a large colony difficult. Is there a way to design a new worksheet that will only contain information from rows that have a breeding cage? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing data into different worksheet | Excel Worksheet Functions | |||
Summarizing monthly worksheet totals | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing field quantities for specific records | Excel Worksheet Functions | |||
Summarizing totals of all worksheets to one worksheet? | Excel Worksheet Functions |