Dear All,
I have excel sheet include all year weeks(52) sheet, I count same item from all sheet per month
problem some sheet have two month data..
I tried this formula but it's too long and will take time, to count Educational Activities in unit for January
=COUNTIF('1-Jan'!C3:L20,C7)+COUNTIF('8-Jan'!C3:L20,C7)+COUNTIF('15-Jan'!C3:L20,C7)+COUNTIF('22-Jan'!C3:L20,C7)+COUNTIF('29-Jan'!C3:G20,C7)
please check report sheet in link below
https://drive.google.com/open?id=0B1NBFgB2DavudXY4YzRLZVE4Yk0<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
I have excel sheet include all year weeks(52) sheet, I count same item from all sheet per month
problem some sheet have two month data..
I tried this formula but it's too long and will take time, to count Educational Activities in unit for January
=COUNTIF('1-Jan'!C3:L20,C7)+COUNTIF('8-Jan'!C3:L20,C7)+COUNTIF('15-Jan'!C3:L20,C7)+COUNTIF('22-Jan'!C3:L20,C7)+COUNTIF('29-Jan'!C3:G20,C7)
please check report sheet in link below
https://drive.google.com/open?id=0B1NBFgB2DavudXY4YzRLZVE4Yk0<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>