In order to provide a summary of performance against about 3000 rows of data, I wish to sum the number of rows in a sheet where several conditions are met.The summary is provided on a separate sheet within the same workbook. This summary sheet also holds the priorities, the target response times and the target response percentages.
The conditions are:
Entry in column A (Priority) is 1 (or 2, 3 or 4)
Entry in column N (Target response time) is greater than a value held in cell B3 in
summary sheet,
Entry in column Q is less than a value held in cell C3 in the summary sheet.
I am trying without success to put together an array formula of the form:
=sum(if(and(condition1 on A1:A9999,condition2 on N1:N9999, condition3 on Q1:Q9999),1))
Can anyone help?
The conditions are:
Entry in column A (Priority) is 1 (or 2, 3 or 4)
Entry in column N (Target response time) is greater than a value held in cell B3 in
summary sheet,
Entry in column Q is less than a value held in cell C3 in the summary sheet.
I am trying without success to put together an array formula of the form:
=sum(if(and(condition1 on A1:A9999,condition2 on N1:N9999, condition3 on Q1:Q9999),1))
Can anyone help?