date range and COUNTIFS

Hi,

I need to look at a series of data once per week and calculate the results. I'm trying to use COUNTIFS to get a result based on both the date I'm doing the analysis for and for the response.

I've attached a sheet that shows a sample of what I'm trying to do. Cell B1 contains the date range I'm using, and cell B18 shows the formula I'm having trouble with. I suspect it's because I'm trying to treat a date like text, but I'm not sure. Any help would be greatly appreciated.

Thanks,
Michael

The arrays have to be the same size in COUNTIFS, and you have to coerce the string to a number.

What are you trying to do?

Dear momus12,

Can you please tel me what do you want to do, so i can help you

thanks

Still not sure what you're trying to do, but maybe this. In B18 and copy down and across,

=IF($B$1 <> $A18, "", COUNTIF(A$4:A$9, "Yes") / COUNTA(A4:A9) )

if you want the percentage of responses The following formula is perfect

=IF($B$1 <> $A18, "", COUNTIF(A$4:A$9, "Yes") / COUNTA(A4:A9)*100 )

I hope this work for you.

Thanks