software

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,quot;TRANFER.*quot;)*

Can anyone here tell me how it would be possible to achieve the same
results in Excel, please?

Brgds,
--
Cain--
Cain
------------------------------------------------------------------------
Cain's Profile: www.excelforum.com/member.php...oamp;userid=31470
View this thread: www.excelforum.com/showthread...hreadid=511508
You can do that in excel too

=COUNTIF(B2:B20,quot;TRANSFER*quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=511508
Thanks ... works like a charm. Leaving that full stop out made all the
difference.

Brgds,--
Cain------------------------------------------------------------------------
Cain's Profile: www.excelforum.com/member.php...oamp;userid=31470
View this thread: www.excelforum.com/showthread...hreadid=511508