I have been playing with OpenOffice 2.0 Calc and found that it had
additional criteria in the COUNTIF and SUMIF functions, such that it is
possible to do a COUNTIF or SUMIF using a regular expression as a
criteria e.g.
If I wanted to count all cells in column B that started with the word
TRANSFER my COUNTIF statement would look like this:
*=COUNTIF(B2:B20,"TRANSFER.*")*
Can anyone here tell me how it would be possible to achieve the same
results in Excel, please?
Brgds,
--
Cain
--
Cain
------------------------------------------------------------------------
Cain's Profile:
http://www.excelforum.com/member.php...o&userid=31470
View this thread:
http://www.excelforum.com/showthread...hreadid=511509