Solved

Sum Per Month

Posted on 2016-10-13
7
32 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
Comment Utility
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 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
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
Comment Utility
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Closing Comment

by:pdvsa
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you for your follow up.  Much appreciated
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
Comment Utility
you are welcome.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

743 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

18 Experts available now in Live!

Get 1:1 Help Now