Sumifs and Averageifs alternative?

[A[L]C]

Hi all,

We are looking at taking on blackberrys, but sumifs and averageifs apparently do not work on them.

We have a few sheets with these forumlas on them. Can anyone suggest an alternative?

=IF(SUMIFS($S$31:$S$81,$H$31:$H$81,L$8,$J$31:$J$81,$K10,B$31:B$81,$MU$6)=0,"",AVERAGEIFS($S$31:$S$81,$H$31:$H$81,L$8,$J$31:$J$81,$K10,B$31:B$81,$MU$6))

Thanks a lot in advance