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)