mattster1010
02-09-2011, 05:45 AM
Afternoon All,
I am using the below formula to count the number of queries between two date ranges.
=COUNTIF('Open NHH Queries'!H:H,"<="&DATE(2009,1,31))-COUNTIF('Open NHH Queries'!H:H,"<"&DATE(2009,1,1))
I need to adapt it slighty and get the formula to also lookup column G:G and 'not' count the query if there is a value in column G:G. Any idea's how I could adapt the formula?
Regards,
Mattster
I am using the below formula to count the number of queries between two date ranges.
=COUNTIF('Open NHH Queries'!H:H,"<="&DATE(2009,1,31))-COUNTIF('Open NHH Queries'!H:H,"<"&DATE(2009,1,1))
I need to adapt it slighty and get the formula to also lookup column G:G and 'not' count the query if there is a value in column G:G. Any idea's how I could adapt the formula?
Regards,
Mattster