COUNTIF question

[missmorph]

Hey,
I am using COUNTIF to count how many times a certain line of text appears in a column which includes about 3000 rows. I want to extend my search to include an additional column but can I write one formula to include two columns?

Thanks!

 

[Aladin Akyurek]

=COUNTIFS(Range,text)

=COUNTIFS(Range,"*"&X2&"*")

where X2 houses the text to count.

 

[Eric W]

If you want to count the instances in another column, then you can just add another COUNTIF, like this:

=COUNTIF(D:D,"text")+COUNTIF(G:G,"text")


If you only want to count a row once if the text appears in both columns, then try:

=COUNTIFS(D:D,"text",G:G,"text")


If the text can appear as part of the cell value, you can use "*text*" instead.

 

[missmorph]

Thank you both