Thread: Sum certain cells in a column if they meet criteria in seperate column

I'm trying to sum only certain values in column F if they are inthe range in column B, ie column F amounts have values from all months, but I just want to sum the cells related to the month of Jan., a which is column B

=SUMIF(B9:B39,"<=12/31/2011", F9:F39) I used this and it worked for anything <= Dec. 31. Dec. was the starting month in my list.


=SUMIF(B9:B39,"1/1/2012:1/31/2012",F9:F39) Now I'm trying to set up something like this, only sum the cells in F that occured in the month on Jan.

Any help is greatly appreciated

Hi,

With the first date/day of your reference month in say C2, i.e. for January 01/01/2012

=SUMIFS(B:B,A:A,">="&C1,A:A,"<="&EOMONTH(C1,0))

Regards

=SUMIFS(F9:F39,B9:B39,">=1/1/2012",B9:B39,"<=1/31/2012")


Regards, TMS

Hi,

Does this do as you ask?

=SUMPRODUCT((F9:F39)*(MONTH(B9:B39)=1))

to include the year as well,

=SUMPRODUCT((F9:F39)*(MONTH(B9:B39)=1)*(YEAR(B9:B39)=2012))

You're welcome. Thanks for the rep.