公式库

Excel Formula To Count Rows If Text Ends With -Old In Imported Csv Text

Count rows when text ends with -OLD in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Count rows if text ends with -OLD in imported csv text.

统一公式

ExcelGoogle SheetsWPS
=COUNTIFS(A:A, "*-OLD")

使用说明

需要定制版本？

相关公式

Excel Formula To Count Rows If Text Ends With -Us In Transaction Text

Count rows when text ends with -US in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Rows If Text Ends With -Eu In Transaction Text

Count rows when text ends with -EU in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Rows If Text Ends With -Apac In Transaction Text

Count rows when text ends with -APAC in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Rows If Text Ends With -Dev In Transaction Text

Count rows when text ends with -DEV in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Rows If Text Ends With -Test In Transaction Text

Count rows when text ends with -TEST in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Count Rows If Text Ends With -Beta In Transaction Text

Count rows when text ends with -BETA in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.