[Exce] Count value only this month

[picmaster]

Hi
I am new to excel and now I'm trying to develop excel to be my cheque management software.

However, I want to count the amount of money that I need to pay for this month.

In column D7:D1000 = Due date of my cheque
In column Q7:Q1000 = Value (TRUE, FALSE) for check that this cheque already paid or not
In column R7:R1000 = Amount of money of the cheque

I want Cell K3 to show how much do I need to pay for this month (this value should depend on the current month that match with cheque)

Thankyou in advance,
Picmaster

 

[VoG]

Try

=SUMPRODUCT(--(MONTH(D7:D1000)=MONTH(TODAY())),--(Q7:Q1000=FALSE),R7:R1000)

 

[Aladin Akyurek]

Is

=SUMPRODUCT(--(TEXT(D7:D1000,"mmmyy")=TEXT(TODAY(),"mmmyy")),1-Q7:Q1000,R7:R1000)

what you want?

 

[picmaster]

Try

=SUMPRODUCT(--(MONTH(D7:D1000)=MONTH(TODAY())),--(Q7:Q1000=FALSE),R7:R1000)

It work ! Thank you so much

Is

=SUMPRODUCT(--(TEXT(D7:D1000,"mmmyy")=TEXT(TODAY(),"mmmyy")),1-Q7:Q1000,R7:R1000)

what you want?

This is absolutely what I was looking for !
Thank you so much VoG you save my life !