Sum column based on two criteria, one being a date

[b.yoxall]

Hi,

Im looking to do the following, I want a cell to total the items in column F it two criteria are met, the first is that the initials BY are in column C and the second is that the date in column A is any day in January. I would then like to copy this 12 times so that it populates for each month.

So far I have:

=sumifs(F1:F100,C1:C100,"BY",A1:100,???)

I cannot work out how to add a formula that will allow the lookup to be any day in a given month.

Thanks

[mehmetcik]

Please Login or Register  to view this content.

[Jonmo1]

Do you need to specify the Year as well ?

Like if the column had both 1/15/2016 and 1/23/2015
Should they BOTH be counted, or only the 2016 ?


This would include the Year element (2016)
=sumifs(F1:F100,C1:C100,"BY",A1:A100,">="&DATE(2016,1,1),A1:A100,"<="&DATE(2016,1,31))

[b.yoxall]

Many thanks Jonmo1, it worked a charm,

[Jonmo1]

You're welcome.