Your formula doesn't return an average, it returns a conditional sum.

Need more detail.

--
Biff
Microsoft Excel MVP


"Andys517" wrote in message
...
I am trying to use the following function to get an average using letters
as
variables under a criteria. However, there are blank cells which are
being
included in the average which is not wanted. I would like to take the
average of just the numbers listed and not blank cells. Please help me.


=SUMIF(ACCT!$D$22:$D$1002,$A$3:$A$17,ACCT!$H$22:$H $1002)