Can I use an array function to solve my question???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

determine a range using a formula 2
Array function - I think! 8
using CountIF function or Array? 3
Help with an array and SUMPRODUCT 3
Return an array of data based on range of date 3
Array? 6
Countif Array 3
XL2000 Array Function Problem 2

Back
Top