|
Contact: Email info@designcad.com.au Tel +61 8 8354 2400 Fax +61 8 +61 8 303 4363 Mob 0418 414 932 Design Cad Pty Ltd (ABN 38 007 890 146) Lasted Updated: 08-Mar-04. |
 |
|
Search and counting in Excel |
|
Q. How do I search for and count a particular entry in an Excel spreadsheet column?
A. If for example, you had several occurrences of the text string "EUTO" in a column running from cell A1 to cell A22, use the formula COUNTIF(A1:A22, "=EUTO") to sum the occurrences.
|
|
Contact: Email info@designcad.com.au Tel +61 8 8354 2400 Fax +61 8 +61 8 303 4363 Mob 0418 414 932 Design Cad Pty Ltd (ABN 38 007 890 146) Lasted Updated: 08-Mar-04. |
|
|