Adding Cells based on being in current month

[Keithadams]

Hi Guys I am looking to create a formula where I can Sum columns abcd i have marked below but only show the result if the date falls in the current month. Is this possible thank you. I want to get the results by row too not as a combined sum.

SO for example row 1 would show 34 as currently in january and row 2 wouldnt show anything as in march.

Hope you can help thank you

Date x x x x x a b c d
01/01/2019 10 9 8 7
01/03/2019 2 2 2 2
01/01/2019 2 0 0 0
31/01/2019 2 0 0 0
05/01/2019 2 0 0 0
06/02/2019 5 0 0 0
07/01/2019 2 2 0 3

[Keithadams]

Untitled.png

im not sure how to attach a extract from excel so i posted this image instead

[Glenn Kennedy]

There are lots if ways to do this. Here's one:
=IF(EOMONTH(A2,0)=EOMONTH(TODAY(),0),SUM(B2:E2),"")

[Keithadams]

thanks glenn

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.