LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin
 
Posts: n/a
Default How Do I use COUNTIF Combining the Text from 2 Columns

I want to do a COUNTIF using the text combine in 2 columns.
I tried using concatenate =COUNTIF(A:A&B:B,"FPP*Conn*") but I get an
formula error

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn Off Text To Columns Rcih Excel Discussion (Misc queries) 2 February 8th 06 09:11 PM
COUNTIF according to presence of string within text Ingeniero1 Excel Worksheet Functions 5 February 1st 06 06:43 PM
Excel is automatically doing "text to columns" upon paste text. robert10000 Excel Discussion (Misc queries) 1 June 15th 05 07:49 PM
Text to Columns - moves text up Stoofer Excel Discussion (Misc queries) 2 February 19th 05 10:04 PM
Filtering Text Data from Multiple columns Brad Excel Worksheet Functions 6 January 1st 05 03:32 PM


All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"