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
Bookmarks