Countif left and alphanumberical data
On Mon, 8 Jun 2009 03:26:01 -0700, Onyx wrote:
I'm wanted to build a formula that will do the following,
CountIF(Column begins with array) I can't see to get the function to work.
Reallife example
Count a column of postcodes to find any postcodes beginning with EH, LG,
etc... and giving me a total
If there are no blanks, you could use this formula:
=SUMPRODUCT(COUNTIF(PostCodes,PostCodeList&"*"))
where PostCodes is the range where you have your column of postcodes, and
PostCodeList is the list of specific codes you wish to count.
--ron
|