Sumif formula on the month basis

[sachar]

Dear All,

With reference to the attach sample file, May I know what is the wrong with Sumif formula the worksheet Cell ”B16” however, there should be the total of Jan, Feb & Mar.

Please help me?
Thanking you.

 

[Naresh Yadav]

Dear Sachar,

pl try this one

=SUMPRODUCT((TEXT(A3:A14,"mmm")={"Jan","Feb","Mar"})*(B3:B14))

 

[Villalobos]

maybe

=SUMIF(A3:A14,"<="&(EOMONTH(TODAY(),-1)),B3:B14)

 

[Deepak]

A little eased where start & end date are defined..


=SUMIFS(B3:B14,A3:A14,">="&DATE(2016,1,1),A3:A14,"<="&DATE(2016,3,31))


Sorter..

=SUMPRODUCT((MONTH(A3:A14)<4)*$B$3:$B$14)

more sorter but CSE
=SUM((MONTH(A3:A14)<4)*$B$3:$B$14)

 

[Naresh Yadav]

thanks Deepak sir for sharing your knowledge with us..

 

[Naresh Yadav]

All your three example was totally out of my knowledge..

 

[Deepak]

One more..

=SUMPRODUCT((MONTH(A3:A14)={1,2,3})*$B$3:$B$14)


Just for fun...

=SUMPRODUCT(NOT(ISERROR(MONTH(A3:A14)={1;2;3}))*$B$3:$B$14)

 

[sachar]

Dear All,

Received with thanks to all.