Countif/Sumif

[Cain]

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

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

Brgds,

 

[daddylonglegs]

You can do that in excel too

=COUNTIF(B2:B20,"TRANSFER*")

 

[Cain]

Thanks ... works like a charm. Leaving that full stop out made all the
difference.

Brgds,