Solved

Sum by month

Posted on 2011-03-14
7
220 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

724 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