Sum of a month using cell reference from date range

[Faruk Hosen]

Hello,
Look at the following formula

=SUMPRODUCT((YEAR($B$2:$B$100)=2016)*(MONTH($B$2:$B$100)=I3)*$C$2:$C$100)

I want to use a cell I3 which is a date. but not working.

Can anyone help?


Thanks.

 

[Naresh Yadav]

Dear faruk,

Pls share some part of your data...

 

[Faruk Hosen]

Dear faruk,

Pls share some part of your data...

Please find attached file.

 

[Naresh Yadav]

Dear Faruk

pls try =SUMPRODUCT((YEAR($B$2:$B$100)=2016)*(MONTH($B$2:$B$100)=MONTH(I3))*$C$2:$C$100)

 

[Faruk Hosen]

Dear Faruk

pls try =SUMPRODUCT((YEAR($B$2:$B$100)=2016)*(MONTH($B$2:$B$100)=MONTH(I3))*$C$2:$C$100)

Thanks!

 

[Naresh Yadav]

OR you can try this one..

=SUMPRODUCT((TEXT($B$2:$B$92,"MMM-YY")=TEXT(I2,"MMM-YY"))*($C$2:$C$92))

 

[Khalid NGO]

Please do not start duplicate question:
http://chandoo.org/forum/threads/sum-of-week-month-quarter-year.29511/#post-177663

 

[Faruk Hosen]

Please do not start duplicate question:
http://chandoo.org/forum/threads/sum-of-week-month-quarter-year.29511/#post-177663

OK.