Hi Everyone,
I have a spreadsheet that I am trying to count the number of clients overall within a certain date range. The data in the file may fall over more than one fiscal year so I would like to be able to formulate reports within a specified time frame.
The uploaded file is a sample.
So my first formula will be if there is an entry with any given program element within April 1/12 to Mar 31/13
My second formula will then split the data up further and provide numbers for All Clients within the JP program between April 1/12 and March 31/13 who are in the client category OW55+
Bookmarks