#### rushthecourt

##### New Member

- Joined
- Jul 8, 2007

- Messages
- 35

Using the following formula:

=SUM(IF(ROW(C4:C4997)>=LARGE(IF(C4:C4997="x",IF(K4:K4997<>"",ROW(C4:C4997))),4),IF(C4:C4997="x",IF(E4:E4997="A",IF(K4:K4997<>"",1)))))&"-"&SUM(IF(ROW(C4:C4997)>=LARGE(IF(C4:C4997="x",IF(K4:K4997<>"",ROW(C4:C4997))),4),IF(C4:C4997="n",IF(E4:E4997="B",IF(K4:K4997<>"",1)))))

I am trying to look the last 4 times col. C = x. If there are 4 or more times where col. C = x, then it gives me a notation that I want (such as 3-1, or 2-2).

The problem arises when there are <4 times where col. C = x. In those cases I'm getting the #NUM! error, rather than the notation 2-1 or 0-3, for example.

Can someone please help?! Thanks.

RTC