ExcelBanter - Count text

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

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

- - Count text (https://www.excelbanter.com/excel-discussion-misc-queries/2165-count-text.html)

Shannon

Count text

I have two columns with text. I'm looking for a formula that will count that
if column A has the word "Aug" and column B has the word "sl" it will give me
a number of time that it occurs.

JE McGimpsey

One way:

=SUMPRODUCT(--(A1:A100="Aug"),--(B1:B100="sl"))

For an explanation of the -- in the formula, see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"Shannon" wrote:

I have two columns with text. I'm looking for a formula that will count that
if column A has the word "Aug" and column B has the word "sl" it will give me
a number of time that it occurs.

All times are GMT +1. The time now is 10:44 AM.