Countif/Sumif
 

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