Sum cells only if 6 weeks before todays date

[JamesMook]

I'm looking for a formula that will sum together cells in a column but only if the data comes from 6 weeks before todays date.

The column with data would be B1:B999
The column with dates would be A1:A999

I'm presuming it would be something like =SUMIF(B1:B999,"<"&TODAY(),A1:A999) however this doesn't specify 6 weeks only. Any one have any ideas?

Thanks

 

[JamesMook]

Sorry i'm have a monday moment, it would need to sum column J:J

I've actually just figured it out now. I simply dropped the variable of searching for '2015' as the last six weeks formula would erase the need for this.

For anyone who this would help the formuala is below. Thanks to everyone who has helped. Really appreciated

=SUMIFS(RAW!J:J,RAW!I:I,"Joe Bloggs", RAW!A:A,">"&(TODAY()-42)

 

[gaz_chops]

Thought it seemed strange to sum A, glad you fixed it.