Anyway to increase number of countable lines?

Hi All,

I am using a formula very similar to this:

=SUMPRODUCT((TEXT(A2:A10,"mmyyyy")=TEXT(TODAY(),"mmyyyy"))*(B2:B10="Name"))

Just the ranges and Name are different. This issue I have is that this formula will only count upto 22521 lines before returning #N/A instead of the value. I currently have 22521 lines to count through Is there something I can do similar, that will count all the lines I have?

Thanks


Jaspa.

is there a value in the range you are using that is #/n/a, this will cause the formula to error, the easiest way is to eliminate this

Originally Posted by davsth

is there a value in the range you are using that is #/n/a, this will cause the formula to error, the easiest way is to eliminate this

Thanks davsth, Thats exactly what the problem is. I'll go try fix it!

Help much appreiated.

Try:

=COUNTIFS(A2:A10,">"&EOMONTH(TODAY(),-1),A2:A10,"<="&EOMONTH(TODAY(),0),B2:B10,"Name")