Formula help.

Hi,

Sorry if this has been asked before.

 

I’m trying to write a formula that will show if an appraisal has been issued but only to a certain area (say North).

 

28 WEEKS RECEIVED MEMO INCREMENT 14 MONTH RECEIVED 22 MONTH RECEIVED MANAGER LAC
24/07/2012 * * 14/08/2012 10/03/2013 * 10/11/2013     North
24/07/2012 * * 14/08/2012 10/03/2013 * 10/11/2013     North
24/07/2012 * * 14/08/2012 10/03/2013 * 10/11/2013 *   North
24/07/2012 * * 14/08/2012 10/03/2013 * 10/11/2013     South
24/07/2012 * * 14/08/2012 10/03/2013 * 10/11/2013 *   South
24/07/2012 * * 14/08/2012 10/03/2013 * 10/11/2013     East

So I have another worksheet to gather the data.  I want to pull this data to show that a 28 week has been issued (shown by the date being inserted) but break it down to areas (under the LAC heading). eg 3 issued to North, 2 south and 1 east.

I’m sure this is really simple to do, but cannot for the life of me work it out!

Thanks.

By: Craig

Leave a Reply

Your email address will not be published. Required fields are marked *