Thanks for your response but it's not quite what I'm looking for in that I don't want to put a specific date. The criteria for searching through column K needs to be is there any entry (any date) or nothing in this column. If there is then how many of those occurances with a date in column K also have the value 'S' in column G.
In such cases it is better to use the mouse to delineanae the various ranges.
that in the second sheet type
take the mouse to the first sheet and drag the mouise from G1 to G10(or last cell)
and then type
and then drag the mouse from K1 down in the second sheet
and type three brackets.
It accepts the formula but doesn't return the right number. I tested it and it seems to only be giving a result for the last record that matches the criteria - so only shows the result as 1 when there should be more than that.
I want it to look for blank cells in column N and then return a result telling me how many of those rows have 'C' in column G (i.e. doing the same thing as the other formula you gave me but instead of looking for a date it's looking for blank cells. I tried ISBLANK but that didn't work.)
Hopefully this displays right. Below is the example. Dues to space constraints here the columns in question for this example are G and D. So if there is no entry in column G then I want it to count how many C's there are for those entries in column D. So the result for this example should be 2.
A B C D E F G
Simon Simmons Officer C Bla Bla 12/05/2012
James Johnson Admin C Bla Bla
Chris Hart Officer C Bla Bla
Sophie Smith Admin S Bla Bla 15/06/2013