ExcelBanter - Countif Text equals the same

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif Text equals the same (https://www.excelbanter.com/excel-discussion-misc-queries/19879-countif-text-equals-same.html)

tamato43

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.

Dave Peterson

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

All times are GMT +1. The time now is 08:58 PM.