Hi All.
This has been a rough ride for me so far. Maybe You can help.
Firstly let me inform you I'm using Excel 2003 at work.
What i need is to create a formula that will count number of cells with a specific text & older than 10 days.
I was able to get a correct number of cells based on a date condition (COUNTIF(C2:C59999,"<"&TODAY()-10)
but when i tried to alter my formula to have a txt condition....it fails.
I've attached simplified version of my report. Is is being run daily so number of errors changes daily.
my formula has to give me a number of let say "not sent" errors older than 10 days, based on "error create date" (not error date in column B).
I hope im not too confusing
I'm new to this formu so please be gentle lol.
Many Thanks
Bookmarks