Hi there,
I don't know if anyone can help.....I am stuck at work, not been on this site before, and am needing to write a formula that will:
Count the results of a search for cells containing specific text, based on a specific date in the first column.
So I want to count the records of specific error types logged on a particular day.
To do this I think the formula has to find all the records written on the date selected, from the first column, and from the records selected find all the errors (text) of that particular type stored in another column.
I have been trying to use LOOKUP and COUNTIF together, but don't know how to link/embed these two functions together, and even if they are the right ones.
Anyone who can help me not have to stay here at work all night would be much appreciated.
Many thanks
Tabs
I don't know if anyone can help.....I am stuck at work, not been on this site before, and am needing to write a formula that will:
Count the results of a search for cells containing specific text, based on a specific date in the first column.
So I want to count the records of specific error types logged on a particular day.
To do this I think the formula has to find all the records written on the date selected, from the first column, and from the records selected find all the errors (text) of that particular type stored in another column.
I have been trying to use LOOKUP and COUNTIF together, but don't know how to link/embed these two functions together, and even if they are the right ones.
Anyone who can help me not have to stay here at work all night would be much appreciated.
Many thanks
Tabs