using countif and counta in single formula

[Muhamat]

hai all,i'm a new guy.i'm trying to make a progress report which wil be calculate in percentage,the formula i'm using is like this (COUNTIFS('WEEKLY REPORT'!$H$6:$H$79,"COMPLETE",'WEEKLY REPORT'!$F$6:$F$79,"HMU/DMU T03",'WEEKLY REPORT'!$G$6:$G$79,"D1")/(COUNTA('WEEKLY REPORT'!$J$6:$J$79)-1) and it goes just fine.
until i'm adding another string in this formula.

when i'm adding another string(COUNTIFS('WEEKLY REPORT'!$H$6:$H$79,"COMPLETE",'WEEKLY REPORT'!$F$6:$F$79,"HMU/DMU T03",'WEEKLY REPORT'!$G$6:$G$79,"D1",'WEEKLY REPORT'!$B$6:$B$33,"WEEK 1")/(COUNTA('WEEKLY REPORT'!$J$6:$J$79)-1) i've just get #value in return.

i don't know where's the error is.Need your help on this

Thanks in Advanced

 

[gaz_chops]

Welcome to Mr Excel,

Check the range REPORT'!$B$6:$B$33

 

[Muhamat]

it work's thanks.for this kind of error i need to use the same range right?

 

[gaz_chops]

Yes the ranges need to be equal size.