AVERAGE formula. PLEASE HELP!!
=AVERAGE(IF((ISNUMBER(B1:B100))*(MONTH(A1:A100)=7) ,B1:B100))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"FPJ" wrote in message
...
I know this is very simple problem to most, if not all, of you here but I
am
trying to figure out how to create the formula to get the average of
column B
of reports created in a certain month (ex. July). Please note that some
cells
in column B have the #VALUE! and the dates in column A are in the x/x/xxxx
format. Please help. Thanks.
|