Barrakooda
Board Regular
- Joined
- Feb 3, 2012
- Messages
- 75
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
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