ironsides
Well-known Member
- Joined
- Aug 12, 2002
- Messages
- 575
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
=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