Formula help with this
=COUNTIF(INDIRECT("$AP19:$AP$9999"&$A$1),"9")
=SUMIF(INDIRECT("$AP$19:$AP$9999"&$A$1),"9",$BD$19:$BD$9999)
I am using these formulas successfully
but Now, instead of using one number, in this case the number 9,
I want to use a range from 11:20
thanks
Ironsides