Difficult Average Function
Hi,
This will include zeroes in the number range but ignore blanks
=AVERAGE(IF((A42:A5000)=A9,IF(J42:J5000<"",J42:J5 000)))
Array entered with CTRL+Shift+Enter
Mike
"Connie Martin" wrote:
I am stumped. How in the world do I write this formula?
In a cell, I want it to find the date in A9 in A42:A5000 and then average
the numbers in J42:J5000 for that date. Hope this is clear. Many thanks in
advance.
Connie
|