AA_20069
11-08-2016, 04:21 AM
If all,,
hoping for some help....
Scenario:
One spreadsheet that has columns A:Z with filter a on O (Filter = "Orange")
Columns C,D,E also contain various "states" will go with Yes,NO,Maybe,Never
Column F also has various "states" will go with Okay,Sort,Leave,Move,Mix
The last data row would be row 1024 (this is a fixed row)
Once the filer has been applied to O ("Orange") then what I am looking to achieve is the following:
If C,D,E to Row 1024 = NO AND F = Okay count all of these and in Cell D1040 out the total
If C,D,E to Row 1024 = NO AND F = Sort count all of these and in Cell D1041 out the total
If C,D,E to Row 1024 = NO AND F = Leave count all of these and in Cell D1042 out the total
If C,D,E to Row 1024 = NO AND F = Move count all of these and in Cell D1043 out the total
If C,D,E to Row 1024 = NO AND F = Mix count all of these and in Cell D1044 out the total
Any help would be greatly appreciated
hoping for some help....
Scenario:
One spreadsheet that has columns A:Z with filter a on O (Filter = "Orange")
Columns C,D,E also contain various "states" will go with Yes,NO,Maybe,Never
Column F also has various "states" will go with Okay,Sort,Leave,Move,Mix
The last data row would be row 1024 (this is a fixed row)
Once the filer has been applied to O ("Orange") then what I am looking to achieve is the following:
If C,D,E to Row 1024 = NO AND F = Okay count all of these and in Cell D1040 out the total
If C,D,E to Row 1024 = NO AND F = Sort count all of these and in Cell D1041 out the total
If C,D,E to Row 1024 = NO AND F = Leave count all of these and in Cell D1042 out the total
If C,D,E to Row 1024 = NO AND F = Move count all of these and in Cell D1043 out the total
If C,D,E to Row 1024 = NO AND F = Mix count all of these and in Cell D1044 out the total
Any help would be greatly appreciated