Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Criteria for worksheet
If you can help figure this out, I would appreciate your help.
I am using this in a macro. Col A is Division ( with Divisions numbers 1-100 but there is a random number of lines for each division). Col B is Amounts- debits and credits Col C contains the number 1 in selected rows Col D is a list of possible divisions 1-100 in numeric order What I would like to do is the following: Look at Column C and if there is a 1 in that cell, then sum the amounts from Col B for each separate Division in Col A and put the sum in Col E beside the corresponding division. Thanks Donna |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple criteria from single worksheet | Excel Discussion (Misc queries) | |||
Find text in another worksheet when multiple criteria are met | Excel Worksheet Functions | |||
Multiple DSUM criteria (MONTH & a numeric value) between worksheet | Excel Worksheet Functions | |||
Lookup 2 criteria across multiple worksheet (Attn: Peo Sjoblom) | Excel Worksheet Functions | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions |