Hi ,

I have the following formula as a startpoint.

Code:
 
COUNTA(iferror(FILTER( C:C; C:C=C2; I:I=I2;D:D=D2; E:E=E2)))
This works fine when the 4 criteria are met.

I want to modify it so that the count is increased when either of the final two criteria are met.

In basic terms, count is increased when C:C=C2 AND I:I=I2 AND (D:D=D2 or E:E=E2)

Please how do I contruct the formula for this requirement?



Thanks in advance
Orson.