Solved

Sum by month

Posted on 2011-03-14
7
216 Views
Last Modified: 2012-05-11
I am trying to sum by month based on the attached spreadsheet.  I have tried searching for an answer to this, and when I use what I think is the correct array formula, I get a #Value error.

Thanks,

Michael expert-exchange-datesum-example.xlsx
0
Comment
Question by:paxtonm
  • 3
  • 2
  • 2
7 Comments
 
LVL 24

Expert Comment

by:jimyX
ID: 35129907
Which column? Can you clarify more please.
0
 

Author Comment

by:paxtonm
ID: 35129917
Sorry, I am trying to sum Column F.
0
 

Author Comment

by:paxtonm
ID: 35129963
I have been getting an error using this formula

=SUMPRODUCT((MONTH($A$2:$A$225)=MONTH(I1)*($B$2:$F$225)))
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35130015
Based on your workbook you would need:
=SUMPRODUCT((MONTH($A$2:$A$225)=MONTH(H2))*($F$2:$F$225))
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 35130030
Safer to check the year too though, unless you will only have one year's data:
=SUMPRODUCT(--(MONTH($A$2:$A$225)=MONTH(H3)),--(YEAR($A$2:$A$225)=YEAR(H3)),$F$2:$F$225)

Note: you could also use a pivot table for a simple summary.
0
 
LVL 24

Expert Comment

by:jimyX
ID: 35130042
Not sure if you have correct columns in that formula:
Column I is empty.
$B$2:$F$225 this is a wide range.
Could you show a sample of what you expect the formula to do? I am not sure I got you correctly.
0
 

Author Closing Comment

by:paxtonm
ID: 35130050
Spot on formula!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Unable to open excel in 2016 is slow 4 21
Question to Pivot table 1 33
Excel 2016 - Black cell borders 11 26
sql server query from excel 3 57
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now