Type the formula, then, instead of hitting the ENTER key like you normally
would, you use the key combination of CTRL,SHIFT,ENTER.

Hold down both the CTRL key and the SHIFT key then hit ENTER. If done
properly Excel will enclose the formula in squiggly braces { }. You can not
just type these braces in, you MUST use the key combo.

Biff

"Woody13" wrote in message
...
Not sure what you mean by this: Entered as an array using the key
combination of CTRL,SHIFT,ENTER (not just ENTER):

Thanks


"Biff" wrote:

Hi!

Try these:

Avaerage:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not
just
ENTER):

=AVERAGE(IF((ISNUMBER(A1:A10))*(MONTH(A1:A10)=1),B 1:B10))

Sum:

=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(MONTH(A1:A10)=1),B1:B10)

Change the month number (=1) as needed.

Biff

"Woody13" wrote in message
...
If you have a string of dates in column A and numbers in column B, and
the
dates cover several years, is there a short cut way to write a formula
and
have it sum or average the information in a particular month? Thanks

Example
1/1/01 3.11
1/2/01 3.55
.