CODEWITHSUNDEEP
excel-formula
Victor John
Victor John

Reputation: 11

How to SUM if date falls in a particular month and is a positive value

=SUM(IF(MONTH($M$3:$M$41982)=1,$K$3:$K$41982,">0"))

How to SUM positive values falling in a particular month? I am entering this but not getting an answer

Upvotes: 1

Views: 159

Answers (1)

CallumDA
CallumDA

Reputation: 12113

Try 

=SUMPRODUCT((MONTH($M$3:$M$41982)=1)*($K$3:$K$41982>0)*$K$3:$K$41982)

You weren't far off with your original formula. You just need to split out evaluating if $K$3:$K$41982 is greater than 0 and then returning the value of $K$3:$K$41982

=SUM(IF(MONTH(A1:A8)=1,IF(B1:B8>0,B1:B8,0)))

With this formula, you have to enter it with Ctrl+Shift+Enter rather than just Enter

Upvotes: 1

Related Questions