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
Bookmarks