Excel 2003 issue CountIf multiple
been on this for about and hour and cant work it out
have 2 columns
on with
C1
C3
C4
C5
D2 etc
C1
in the next colum is got a percent working out so
3.4%
2.4%
-0.02%
0.4%
#Div
1.0%
basically i want to count when its >0
and to which Line C1 C3
so in this example C1=2, C3=1 , C4= 0, C5=1, D2=0
etc
have used
=SUM(($Q$4:$Q$66=L76)*($AL$4:$AL$66>0))
=SUM(IF(Q4:Q66="C1",IF(AL4:AL66>0,1,0),0))
=COUNT(IF(Q4:Q66="D4",IF(AL4:AL66>0)))
none have worked but i know
=COUNTIF(AL4:AL66,">=0") will pick the total up eg =4
and so will
=COUNTIF(Q4:Q68,"C1") = 2
keep getin mutliples or #value or #div
but doesnt seem to go together and know about the "CNTL+SHFT+ENTER"
any help?? thanks in advance