I use Excel 2007, and have the following formula in a fairly large spreadsheet.
=(AVERAGEIFS($DQ$2:$DQ$949726,$AO$2:$AO$949726,$F$3,$AV$2:$AV$949726,$A$60,$CF$2:$CF$949726,">0",$AH$2:$AH$949726,$C$5,$AH$2:$AH$949726,$C$6,$BA$2:$BA$949726,1,$AU$2:$AU$949726,$B$7,$AU$2:$AU$949726,$B$8,$AU$2:$AU$949726,$B$9)/220)
This works correctly. However I want to change the $CF$2:$CF$949726,">0", part of the formula. The new part I want is $CF$2:$CF$949726,">$e$25",. Unfortunately when I do this I get the ~DIV/0! error, presumably because cell e25 is a variable numeric entry. If I put in the actual number the result is fine.
Does anybody know a workround for this?
Many thanks
chrisb
Bookmarks