CODEWITHSUNDEEP
excel
bern nick
bern nick

Reputation: 1

Excel, how to Sum on Column based on if the dates in another Column match the current month?

I need to find the sum of the cells in a Column if their end dates in another column occur in the current month.

I tried using the formula =sumif(L:L,MONTH(TODAY()),J:J) but it doesn't work.

Column L contains the full date (ex: 12/1/18).

Column J contains the values I want to add up.

So since it's December, I want to add all the values in J that have a date that is in December, and so on a so forth when I use the sheet in January.

Upvotes: 0

Views: 1071

Answers (1)

Lisa
Lisa

Reputation: 552

Try this formula:

=SUM(IF(MONTH(L:L)=MONTH(TODAY()),J:J,0))

and enter it with Ctrl-Shift-Enter as it is an array formula.

Or use =SUMPRODUCT((J:J)*(MONTH(L:L)=MONTH(TODAY())))

Upvotes: 1

Related Questions