C
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,"TRANSFER.*")*
Can anyone here tell me how it would be possible to achieve the same
results in Excel, please?
Brgds,
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,