Claire2606
New Member
- Joined
- Sep 1, 2014
- Messages
- 12
Hi,
I am putting together a spreadsheet to gather statistical data on a monthly basis over the course of a year.
On sheet one the end date is in column G. My formulas for gathering numbers of new referrals and completed clients are working. However, the formula I am using to gather information on ongoing clients within a month, works, until an end date is inputted in the cell. i.e A client referred in September with a blank end date is counted. When the date is inputted e.g. October, the client is not then counted as being ongoing/being live in September.
I have tried numerous formulas to no avail either they produce errors or incorrect data. The formula I am currently using is:
=SUMPRODUCT(--(LEN(Sheet1!$G$9:$G$350)<=0),--(Sheet1!$D$9:$D$350="Male"),--(Sheet1!$C$9:$C$350="Year 6"),--(Sheet1!$I$9:$I$350="Not known"))
Any help would be gratefully received. Thanks in advance.
I am putting together a spreadsheet to gather statistical data on a monthly basis over the course of a year.
On sheet one the end date is in column G. My formulas for gathering numbers of new referrals and completed clients are working. However, the formula I am using to gather information on ongoing clients within a month, works, until an end date is inputted in the cell. i.e A client referred in September with a blank end date is counted. When the date is inputted e.g. October, the client is not then counted as being ongoing/being live in September.
I have tried numerous formulas to no avail either they produce errors or incorrect data. The formula I am currently using is:
=SUMPRODUCT(--(LEN(Sheet1!$G$9:$G$350)<=0),--(Sheet1!$D$9:$D$350="Male"),--(Sheet1!$C$9:$C$350="Year 6"),--(Sheet1!$I$9:$I$350="Not known"))
Any help would be gratefully received. Thanks in advance.
