| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Countif Text equals the same
I'd like to build a formula that states Countif the Text on cell equals the
same text on cell B. I'm sure its an easy one. |
|
#2
|
|||
|
|||
|
One way:
=SUMPRODUCT(--(A1:A25=B1:B25)) Extend the range as far as you need--but don't use the whole column. =sumproduct() likes to work with numbers. The -- converts the true/falses to 1/0's. tamato43 wrote: I'd like to build a formula that states Countif the Text on cell equals the same text on cell B. I'm sure its an easy one. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF with text | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| COUNTIF text where there is more than one word in a cell | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions | |||
Hybrid Mode
