Sum data depending on a date

[awwcraig]

I have a workbook full of a bunch of sheets with the same formatting. Each sheet has data for a 2 week period.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am making a “master” type sheet and I’m hoping to be able to pull some data from each sheet.<o></o>
<o></o>
On each sheet:<o></o>
Row 1 has dates starting on E1 and ending on AF1 (several blank/combined columns)<o></o>
Row 22 has the data I want to pull, and it is one column to the right of the date. So, F22 corresponds with E1…<o></o>
<o></o>
Ex.<o></o>
One sheet looks like this:<o></o>
E1 = 8/24/09<o></o>
AF1 = 9/6/09<o></o>
<o></o>
I got single amounts to work by using:<o></o>
<o></o>
=IF((MONTH(E1)=8),F22," ")<o></o>
<o></o>
However, I’m hoping to find a formula that would look at the entire two week period and sum the row 22 amounts for each day that falls within a certain month.<o></o>
<o></o>
I tried:<o></o>
=IF((MONTH(E1:AG1)=8),F22:AG22," ")<o></o>
<o></o>
Which comes back false since not all days in the two week period fall within August (8).<o></o>
<o></o>
Does anyone have any ideas for a formula that would be easily changeable, and that would pull & sum row 22 data for each row 1 date that falls within a certain month?<o></o>
<o></o>
Thanks much,<o></o>

 

[awwcraig]

Awesome, that second one is exactly what I needed. Instead of designating like A1 as the month, using 1-12 for the months worked. I got everything working now.

Thanks much