Need help with conditional formulas

[DCMADiva87]

Hello,

I really need help with a few formulas on the attached Excel spreadsheet. First, on the "UCA Summary Data" tab I need help finding a formula to count the number of UCAs that WILL become overage in FY2010 & FY2011, the one I have now only counts the ones that are currently overage, and I need it to be forward looking. Second, on the "UCA Data Input Sheet" I need help with all of the formulas in the second table. I'm not sure how to find formulas that will separate each statistic (Actual % overage, # > 180 days, total on hand, etc.) by month. Any help with either/both problems is greatly appreciated!

[shg]

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.