Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting only if multiple cells match up
I work with maintenance in the military and I am trying to setup an easier
way to keep a running total for broken vehicles. I am trying to setup my worksheet to where it will count the number of times multiple cells in a row match up. For example SHEET 1: A B C 1 VEH STATUS COMPANY 2 M1 X ALPHA 3 M1 X HHB 4 M109 X ALPHA SHEET 2 A B C D E 1 HHB ALPHA 2 OH FMC OH FMC 3 M1 5 4 5 4 4 M109 8 8 8 7 The formual needs to happen in 'sheet 2'!C3:D3 and 'sheet 2'!C3:D3. I'm new to the If, and Count Formulas and I'm having trouble getting this one to work. Any help would be appreciated. Thanks Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting only if multiple cells match up
You probably need a sumproduct formula. here is an excellent resource.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Eric" wrote: I work with maintenance in the military and I am trying to setup an easier way to keep a running total for broken vehicles. I am trying to setup my worksheet to where it will count the number of times multiple cells in a row match up. For example SHEET 1: A B C 1 VEH STATUS COMPANY 2 M1 X ALPHA 3 M1 X HHB 4 M109 X ALPHA SHEET 2 A B C D E 1 HHB ALPHA 2 OH FMC OH FMC 3 M1 5 4 5 4 4 M109 8 8 8 7 The formual needs to happen in 'sheet 2'!C3:D3 and 'sheet 2'!C3:D3. I'm new to the If, and Count Formulas and I'm having trouble getting this one to work. Any help would be appreciated. Thanks Eric |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting only if multiple cells match up
Not easy to see what you want from the explanation! But... You probably want to use a Pivot Table. If you've never used them, try something like http://www.geocities.com/jonpeltier/...ivottables.htm for an explanation. What makes your situation different, is that you need to create a composite key for each entry. Can I suggest creating a new column eg A1 = B1&C1&D1 etc. -- MartinShort Software Tester ------------------------------------------------------------------------ MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034 View this thread: http://www.excelforum.com/showthread...hreadid=546836 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
Counting cells that match 2 criteria | Excel Discussion (Misc queries) | |||
Counting cells using multiple parameters | Excel Discussion (Misc queries) | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
counting cells using multiple criteria | Excel Programming |