Prev: replace a single character WITH FORMAT in a cell
Next: My Excel operates as if Ctrl is always depressed. Help!
From: Bernd P on 23 Feb 2010 03:45
Hello,

> I have a problem with Countif, and that is it seems to only work where the
> criteria is 255 characters or less.

Yes, Countif and Sumif only accept 255 characters here.

[A German link: http://www.xlam.ch/xlimits/worksheetfunctions.htm]

As already suggested, you might want to use Sumproduct:
http://sulprobil.com/html/countif1.html

Regards,
Bernd
First  |  Prev  | 
Pages: 1 2
Prev: replace a single character WITH FORMAT in a cell
Next: My Excel operates as if Ctrl is always depressed. Help!