Average function help

[Andys517]

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)

 

[T. Valko]

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

Need more detail.

 

[Andys517]

Sorry here is the one that returns a Value answer.

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

Please let me know if you have any additional questions. I appreciate your
assistance.

 

[Andys517]

Sorry, here is the average formula I'm using

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

 

[T. Valko]

Ok, here's my best guess:

Array entered** :

=AVERAGE(IF(ISNUMBER(MATCH(ACCT!$D$22:$D$1002,$A$3:$A$17,0)),ACCT!$H$22:$H$1002))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)