View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.