Solved

Sum Per Month

Posted on 2016-10-13
7
43 Views
Last Modified: 2016-10-13
Experts,

How can I sum the attached per month?

thank you
screenprintSum-Per-Month.xlsx
0
Comment
Question by:pdvsa
  • 4
  • 2
7 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 41841757
put this and drag right

=SUMPRODUCT((MONTH($B$3:$KV$3)=MONTH(B$1))*($B$4:$KV$4))

see attached.
Sum-Per-Month.xlsx
0
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41841765
Hi,

pls try
=SUMPRODUCT(--(DATE(YEAR($B$3:$KV$3),MONTH($B3:$KV$3),1)=B1),$B$4:$KV$4)

Open in new window

Regards
Sum-Per-MonthV1.xlsx
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 41841768
correction to my formula above

=SUMPRODUCT((MONTH($B$3:$KV$3)=MONTH(B$1))*((YEAR($B$3:$KV$3)=YEAR(B$1))*($B$4:$KV$4)))
Sum-Per-Month.xlsx
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Author Closing Comment

by:pdvsa
ID: 41841771
Thank you.  Rgonzo's accounted for the years which is what I was after.  August 2016 and August 2017 were the same answer under Professor's.  I might have not made that so clear though.
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 41841773
glad Rgonzo's solution worked for you. i did not notice at first glace your data had multiple years, so i posted a modified formula which is =SUMPRODUCT((MONTH($B$3:$KV$3)=MONTH(B$1))*((YEAR($B$3:$KV$3)=YEAR(B$1))*($B$4:$KV$4))) which works too.
0
 

Author Comment

by:pdvsa
ID: 41842037
Thank you for your follow up.  Much appreciated
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 41842244
you are welcome.
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
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 demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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.

777 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