I have a spreadsheet that I am importing external data into. The Data has a
Date in column A some other stuff in columns B,C,and D, a numerical Value in
Column E, and a value or nothing in column F. This is probably a stupid
question but I am not very familiar with array functions. What I want to do
is sum column E for each month in a year, and for each month in a year as
well I would like to count the number of entries in column F. Can this be
done with array functions, and if so can someone give me a hint?

For month of July (7) use:

(1)
=SUMPRODUCT(--(MONTH(A1:A100)=7),--(E1:E100))

(2)
=SUMPRODUCT(--(MONTH(A1:A100)=7),--(F1:F100<""))

HTH

"Oshtruck user" wrote:

I have a spreadsheet that I am importing external data into. The Data has a
Date in column A some other stuff in columns B,C,and D, a numerical Value in
Column E, and a value or nothing in column F. This is probably a stupid
question but I am not very familiar with array functions. What I want to do
is sum column E for each month in a year, and for each month in a year as
well I would like to count the number of entries in column F. Can this be
done with array functions, and if so can someone give me a hint?