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 |
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 |