Thanks SteveWcg and Pecoflyer for the quick reply. I was wondering why both of you gave me the sum of 2 quarters AR numbers. Apparently the summary data given is incorrect. The fiscal period is arranged in quarterly manner. Apologies for this error made. I have reattached the worksheet and highlighted the Summary sheet and Revenue sheet for FY12Q1 AR numbers in yellow while FY12Q2 AR numbers in blue. Could you advise how to formulate the condition to get the Revenue number from Revenue sheet.
Thanks a lot!
|