Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with COUNTIF
Column CX contains entries that either begin with a "B" or "O". I need to
count the number of cells whose contents begin with "B", and count the number of cells whose contents begin with "O". I wrote the following formula, and even saved it as an array formula, but I keep getting a circular reference error: =COUNTIF(CX:CX,LEFT(CX:CX,1)="B") Any help would be greatly appreciated. Thanks. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct vs. countif | Excel Discussion (Misc queries) | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |