Sum Per Month

pdvsa
pdvsa used Ask the Experts™
on
Experts,

How can I sum the attached per month?

thank you
screenprintSum-Per-Month.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
put this and drag right

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

see attached.
Sum-Per-Month.xlsx
Top Expert 2016
Commented:
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
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
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
pdvsaProject finance

Author

Commented:
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.
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
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.
pdvsaProject finance

Author

Commented:
Thank you for your follow up.  Much appreciated
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
you are welcome.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial