I have a Date column, a percentage column, and a balance column. I want to
add all balances between a specific date to 30 days after that date and all
balances between those dates above a certain percentage.

Date Pctg. Balance
7/15/05 50% 10000
7/29/05 75% 15000
7/31/05 75% 15544
8/08/05 50% 12344

I want the formula to review from 7/15/05 to 8/15/05 and everything above
50% and add the balances that qualify.