Counting days between 2 dates

[ExcelFanatic]

I have 2 worksheets in my workbook. The first tracks events. The second is a summary sheet which shows cycle periods for my offices. I need column F in the summary sheet to sum column G of my event worksheet if the event start and end dates fall between the cycle start and end dates.

EVENT WORKSHEET
<font size="2">Worksheet: Sheet3 UsedRange: $A$1:$Q$14 Range: $A$1:$H$14</font><br /><br /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2"> </font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">A</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">B</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">C</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">D</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">E</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">F</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">G</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">H</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">1</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA1_705"></a><font size="2">Branch</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB1_705"></a><font size="2">Planned Start Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC1_705"></a><font size="2">Actual Start Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD1_705"></a><font size="2">Planned End Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE1_705"></a><font size="2">Actual End Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF1_705"></a><font size="2">Event Length</font></td><td width="100px" style="background-color:#ffffff;"><a name="cG1_705"></a><font size="2">Days Used</font></td><td width="100px" style="background-color:#ffffff;"><a name="cH1_705"></a><font size="2">Future Projected</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA2_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB2_705"></a><font size="2">5/19/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC2_705"></a><font size="2">5/19/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD2_705"></a><font size="2">5/21/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE2_705"></a><font size="2">5/21/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF2_705"></a><font size="2"><a title="=IF($E2="",$D2,$E2)-IF($C2="",$B2,$C2)" href="#fF2_705">2</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG2_705"></a><font size="2"><a title="=IF($E2="",TODAY(),$E2)-IF($C2="",TODAY(),$C2)" href="#fG2_705">2</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH2_705"></a><font size="2"><a title="=F2-G2" href="#fH2_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA3_705"></a><font size="2">Cleveland Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB3_705"></a><font size="2">5/22/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC3_705"></a><font size="2">5/22/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD3_705"></a><font size="2">5/26/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE3_705"></a><font size="2">5/26/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF3_705"></a><font size="2"><a title="=IF(E3="",D3,E3)-IF(C3="",B3,C3)" href="#fF3_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG3_705"></a><font size="2"><a title="=IF($E3="",TODAY(),$E3)-IF($C3="",TODAY(),$C3)" href="#fG3_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH3_705"></a><font size="2"><a title="=F3-G3" href="#fH3_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA4_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB4_705"></a><font size="2">5/23/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC4_705"></a><font size="2">5/23/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD4_705"></a><font size="2">5/25/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE4_705"></a><font size="2">5/25/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF4_705"></a><font size="2"><a title="=IF(E4="",D4,E4)-IF(C4="",B4,C4)" href="#fF4_705">2</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG4_705"></a><font size="2"><a title="=IF($E4="",TODAY(),$E4)-IF($C4="",TODAY(),$C4)" href="#fG4_705">2</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH4_705"></a><font size="2"><a title="=F4-G4" href="#fH4_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">5</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA5_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB5_705"></a><font size="2">5/24/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC5_705"></a><font size="2">5/24/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD5_705"></a><font size="2">5/30/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE5_705"></a><font size="2">5/28/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF5_705"></a><font size="2"><a title="=IF(E5="",D5,E5)-IF(C5="",B5,C5)" href="#fF5_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG5_705"></a><font size="2"><a title="=IF($E5="",TODAY(),$E5)-IF($C5="",TODAY(),$C5)" href="#fG5_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH5_705"></a><font size="2"><a title="=F5-G5" href="#fH5_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">6</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA6_705"></a><font size="2">Cleveland Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB6_705"></a><font size="2">5/24/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC6_705"></a><font size="2">5/24/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD6_705"></a><font size="2">5/30/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE6_705"></a><font size="2">5/28/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF6_705"></a><font size="2"><a title="=IF(E6="",D6,E6)-IF(C6="",B6,C6)" href="#fF6_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG6_705"></a><font size="2"><a title="=IF($E6="",TODAY(),$E6)-IF($C6="",TODAY(),$C6)" href="#fG6_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH6_705"></a><font size="2"><a title="=F6-G6" href="#fH6_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">7</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA7_705"></a><font size="2">Cleveland Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB7_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC7_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD7_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE7_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF7_705"></a><font size="2"><a title="=IF(E7="",D7,E7)-IF(C7="",B7,C7)" href="#fF7_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG7_705"></a><font size="2"><a title="=IF($E7="",TODAY(),$E7)-IF($C7="",TODAY(),$C7)" href="#fG7_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH7_705"></a><font size="2"><a title="=F7-G7" href="#fH7_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">8</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA8_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB8_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC8_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD8_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE8_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF8_705"></a><font size="2"><a title="=IF(E8="",D8,E8)-IF(C8="",B8,C8)" href="#fF8_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG8_705"></a><font size="2"><a title="=IF($E8="",TODAY(),$E8)-IF($C8="",TODAY(),$C8)" href="#fG8_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH8_705"></a><font size="2"><a title="=F8-G8" href="#fH8_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">9</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA9_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB9_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC9_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD9_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE9_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF9_705"></a><font size="2"><a title="=IF(E9="",D9,E9)-IF(C9="",B9,C9)" href="#fF9_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG9_705"></a><font size="2"><a title="=IF($E9="",TODAY(),$E9)-IF($C9="",TODAY(),$C9)" href="#fG9_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH9_705"></a><font size="2"><a title="=F9-G9" href="#fH9_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">10</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA10_705"></a><font size="2">Cleveland Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB10_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC10_705"></a><font size="2">6/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD10_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE10_705"></a><font size="2">6/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF10_705"></a><font size="2"><a title="=IF(E10="",D10,E10)-IF(C10="",B10,C10)" href="#fF10_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG10_705"></a><font size="2"><a title="=IF($E10="",TODAY(),$E10)-IF($C10="",TODAY(),$C10)" href="#fG10_705">3</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH10_705"></a><font size="2"><a title="=F10-G10" href="#fH10_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">11</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA11_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB11_705"></a><font size="2">6/7/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC11_705"></a><font size="2">6/7/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD11_705"></a><font size="2">6/11/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE11_705"></a><font size="2">6/11/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF11_705"></a><font size="2"><a title="=IF(E11="",D11,E11)-IF(C11="",B11,C11)" href="#fF11_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG11_705"></a><font size="2"><a title="=IF($E11="",TODAY(),$E11)-IF($C11="",TODAY(),$C11)" href="#fG11_705">4</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH11_705"></a><font size="2"><a title="=F11-G11" href="#fH11_705">0</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">12</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA12_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB12_705"></a><font size="2">6/12/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC12_705"></a><font size="2">6/12/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD12_705"></a><font size="2">7/2/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE12_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cF12_705"></a><font size="2"><a title="=IF(E12="",D12,E12)-IF(C12="",B12,C12)" href="#fF12_705">20</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG12_705"></a><font size="2"><a title="=IF($E12="",TODAY(),$E12)-IF($C12="",TODAY(),$C12)" href="#fG12_705">10</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH12_705"></a><font size="2"><a title="=F12-G12" href="#fH12_705">10</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">13</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA13_705"></a><font size="2">Cleveland Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB13_705"></a><font size="2">7/2/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC13_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cD13_705"></a><font size="2">7/12/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE13_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cF13_705"></a><font size="2"><a title="=IF(E13="",D13,E13)-IF(C13="",B13,C13)" href="#fF13_705">10</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG13_705"></a><font size="2"><a title="=IF($E13="",TODAY(),$E13)-IF($C13="",TODAY(),$C13)" href="#fG13_705">0</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH13_705"></a><font size="2"><a title="=F13-G13" href="#fH13_705">10</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">14</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA14_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB14_705"></a><font size="2">6/24/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC14_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cD14_705"></a><font size="2">7/12/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE14_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cF14_705"></a><font size="2"><a title="=IF(E14="",D14,E14)-IF(C14="",B14,C14)" href="#fF14_705">18</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG14_705"></a><font size="2"><a title="=IF($E14="",TODAY(),$E14)-IF($C14="",TODAY(),$C14)" href="#fG14_705">0</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH14_705"></a><font size="2"><a title="=F14-G14" href="#fH14_705">18</a></font></td></table></div><p /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Address</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Value</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Formula</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF2_705"></a><font size="2"><a href="#cF2_705">F2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E2="",$D2,$E2)-IF($C2="",$B2,$C2)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG2_705"></a><font size="2"><a href="#cG2_705">G2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E2="",TODAY(),$E2)-IF($C2="",TODAY(),$C2)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH2_705"></a><font size="2"><a href="#cH2_705">H2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F2-G2</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF3_705"></a><font size="2"><a href="#cF3_705">F3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E3="",D3,E3)-IF(C3="",B3,C3)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG3_705"></a><font size="2"><a href="#cG3_705">G3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E3="",TODAY(),$E3)-IF($C3="",TODAY(),$C3)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH3_705"></a><font size="2"><a href="#cH3_705">H3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F3-G3</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF4_705"></a><font size="2"><a href="#cF4_705">F4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E4="",D4,E4)-IF(C4="",B4,C4)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG4_705"></a><font size="2"><a href="#cG4_705">G4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E4="",TODAY(),$E4)-IF($C4="",TODAY(),$C4)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH4_705"></a><font size="2"><a href="#cH4_705">H4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F4-G4</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF5_705"></a><font size="2"><a href="#cF5_705">F5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E5="",D5,E5)-IF(C5="",B5,C5)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG5_705"></a><font size="2"><a href="#cG5_705">G5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E5="",TODAY(),$E5)-IF($C5="",TODAY(),$C5)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH5_705"></a><font size="2"><a href="#cH5_705">H5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F5-G5</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF6_705"></a><font size="2"><a href="#cF6_705">F6</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E6="",D6,E6)-IF(C6="",B6,C6)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG6_705"></a><font size="2"><a href="#cG6_705">G6</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E6="",TODAY(),$E6)-IF($C6="",TODAY(),$C6)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH6_705"></a><font size="2"><a href="#cH6_705">H6</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F6-G6</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF7_705"></a><font size="2"><a href="#cF7_705">F7</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E7="",D7,E7)-IF(C7="",B7,C7)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG7_705"></a><font size="2"><a href="#cG7_705">G7</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E7="",TODAY(),$E7)-IF($C7="",TODAY(),$C7)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH7_705"></a><font size="2"><a href="#cH7_705">H7</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F7-G7</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF8_705"></a><font size="2"><a href="#cF8_705">F8</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E8="",D8,E8)-IF(C8="",B8,C8)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG8_705"></a><font size="2"><a href="#cG8_705">G8</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E8="",TODAY(),$E8)-IF($C8="",TODAY(),$C8)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH8_705"></a><font size="2"><a href="#cH8_705">H8</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F8-G8</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF9_705"></a><font size="2"><a href="#cF9_705">F9</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E9="",D9,E9)-IF(C9="",B9,C9)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG9_705"></a><font size="2"><a href="#cG9_705">G9</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E9="",TODAY(),$E9)-IF($C9="",TODAY(),$C9)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH9_705"></a><font size="2"><a href="#cH9_705">H9</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F9-G9</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF10_705"></a><font size="2"><a href="#cF10_705">F10</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E10="",D10,E10)-IF(C10="",B10,C10)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG10_705"></a><font size="2"><a href="#cG10_705">G10</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E10="",TODAY(),$E10)-IF($C10="",TODAY(),$C10)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH10_705"></a><font size="2"><a href="#cH10_705">H10</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F10-G10</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF11_705"></a><font size="2"><a href="#cF11_705">F11</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E11="",D11,E11)-IF(C11="",B11,C11)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG11_705"></a><font size="2"><a href="#cG11_705">G11</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E11="",TODAY(),$E11)-IF($C11="",TODAY(),$C11)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH11_705"></a><font size="2"><a href="#cH11_705">H11</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F11-G11</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF12_705"></a><font size="2"><a href="#cF12_705">F12</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">20</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E12="",D12,E12)-IF(C12="",B12,C12)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG12_705"></a><font size="2"><a href="#cG12_705">G12</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">10</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E12="",TODAY(),$E12)-IF($C12="",TODAY(),$C12)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH12_705"></a><font size="2"><a href="#cH12_705">H12</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">10</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F12-G12</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF13_705"></a><font size="2"><a href="#cF13_705">F13</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">10</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E13="",D13,E13)-IF(C13="",B13,C13)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG13_705"></a><font size="2"><a href="#cG13_705">G13</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E13="",TODAY(),$E13)-IF($C13="",TODAY(),$C13)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH13_705"></a><font size="2"><a href="#cH13_705">H13</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">10</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F13-G13</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF14_705"></a><font size="2"><a href="#cF14_705">F14</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">18</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(E14="",D14,E14)-IF(C14="",B14,C14)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG14_705"></a><font size="2"><a href="#cG14_705">G14</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF($E14="",TODAY(),$E14)-IF($C14="",TODAY(),$C14)</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH14_705"></a><font size="2"><a href="#cH14_705">H14</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">18</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=F14-G14</font></td></tr></table></div>

CYCLE WORKSHEET
<font size="2">Worksheet: Sheet3 UsedRange: $A$1:$H$20 Range: $A$18:$G$20</font><br /><br /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2"> </font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">A</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">B</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">C</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">D</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">E</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">F</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">G</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">18</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA18_705"></a><font size="2">Branch</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB18_705"></a><font size="2">Cycle Start</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC18_705"></a><font size="2">Cycle End</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD18_705"></a><font size="2">Length (Days)</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE18_705"></a><font size="2">Length (Months)</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF18_705"></a><font size="2">Used</font></td><td width="100px" style="background-color:#ffffff;"><a name="cG18_705"></a><font size="2">Projected</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">19</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA19_705"></a><font size="2">Coronado Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB19_705"></a><font size="2">5/26/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC19_705"></a><font size="2">9/30/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD19_705"></a><font size="2"><a title="=C19-B19" href="#fD19_705">127</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cE19_705"></a><font size="2"><a title="=D19/30" href="#fE19_705">4.23333333333333</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cF19_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG19_705"></a><font size="2"></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">20</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA20_705"></a><font size="2">Cleveland Office</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB20_705"></a><font size="2">5/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC20_705"></a><font size="2">9/30/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD20_705"></a><font size="2"><a title="=C20-B20" href="#fD20_705">152</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cE20_705"></a><font size="2"><a title="=D20/30" href="#fE20_705">5.06666666666667</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cF20_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG20_705"></a><font size="2"></font></td></table></div><p /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Address</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Value</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Formula</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fD19_705"></a><font size="2"><a href="#cD19_705">D19</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">127</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=C19-B19</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fE19_705"></a><font size="2"><a href="#cE19_705">E19</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">4.23333333333333</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=D19/30</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fD20_705"></a><font size="2"><a href="#cD20_705">D20</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">152</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=C20-B20</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fE20_705"></a><font size="2"><a href="#cE20_705">E20</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">5.06666666666667</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=D20/30</font></td></tr></table></div>

 

[ExcelFanatic]

I figured out the formula for column F of the Cycle worksheet:
=SUMIFS($G$2:$G$14,$A$2:$A$14,$A19,$C$2:$C$14,">="&$B19,$E$2:$E$14,"<="&$C19)

However - now I need column G of the cycle worksheet to sum column H of the event worksheet using the same parameters however if column C or E are blank, I want to use the dates in columns B and D.

Any ideas?