- Joined
- Jun 10, 2009
- Messages
- 2
- Reaction score
- 0
Hello i am having lots of problems with the following issue;
I am trying to count the number of accounts that are within a certian age range and that have a balance other than zero.
I currently have =countif(S:S,">"&G3-61) this counts the number of accounts that fall within the range of G3 (eg 01/06/2009) less 61 days. I am trying to combine this to eclude accounts that have a balance of zero in column Z.
I have tried the following;
{=SUMPRODUCT((S:S>G3)*1,(Z:Z>0)*1)}
{=SUM(IF(S:S>G3,IF(Z:Z>0,1,0)))}
I understand that this doesnt take account of my date range ie(G3-61) but just thought i would try and make this work first and it doesnt like it. No idea why or how to even begin to attempt adding in the date range criteria.
Hope that this makes sense and all help/comments will be greatly appreciated
I am trying to count the number of accounts that are within a certian age range and that have a balance other than zero.
I currently have =countif(S:S,">"&G3-61) this counts the number of accounts that fall within the range of G3 (eg 01/06/2009) less 61 days. I am trying to combine this to eclude accounts that have a balance of zero in column Z.
I have tried the following;
{=SUMPRODUCT((S:S>G3)*1,(Z:Z>0)*1)}
{=SUM(IF(S:S>G3,IF(Z:Z>0,1,0)))}
I understand that this doesnt take account of my date range ie(G3-61) but just thought i would try and make this work first and it doesnt like it. No idea why or how to even begin to attempt adding in the date range criteria.
Hope that this makes sense and all help/comments will be greatly appreciated