Formula based on dates & text

[Barrakooda]

Hi all

I am trying to create a formula that will count the dates older than 30 days based on a date in another cell but only if it has REL in another cell on the same row

I am using =IF('WO Settlement Week 34'!$K:$K,"REL",COUNTIF('WO Settlement Week 34'!$G:$G,"<"&($B$2-30)))

The Countif formula works perfectly on its own, retuning a correct count (which I manually checked).

However when I add the IF it return VALUE

Any ideas?

Thanks

Nathan

 

[Barrakooda]

Looks like I managed to sort it out with

=COUNTIFS('WO Settlement Week 34'!$K:$K, "REL", 'WO Settlement Week 34'!$G:$G,"<"&$B$2-30)