Include blank cells when using the AverageIfs

[ssvv]

I am using the following formula. However, I want it to take the average of all D3:D258 cells taking into account the blank cells. (Considering blank cells as zero values)

=AVERAGEIFS(D3:D258,$A$3:$A$258,$C$266,$B$3:$B$258,"")


Please help. Thank you.

 

[Jonmo1]

Not tested but perhaps this entered with CTRL + SHIFT + ENTER

=AVERAGEIFS(D3:D258+0,$A$3:$A$258,$C$266,$B$3:$B$258,"")

 

[Jonmo1]

Nope, now that I got access to my xl2007, it doesn't work..

You'll have to resort to the xl2003 method...

=AVERAGE(IF(($A$3:$A$258=$C$266)*($B$3:$B$258=""),D3:D258))

Entered with CTRL + SHIFT + ENTER

 

[ssvv]

It worked in 2010. Thanks.