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)

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)

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.

"T. Valko" wrote:

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)

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))

"Andys517" wrote:

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)

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)


--
Biff
Microsoft Excel MVP


"Andys517" wrote in message
...
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.

"T. Valko" wrote:

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)