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