IFCOUNT function with text and digits within same cell

Suzannemlynch

New Member
Joined
Aug 23, 2007
Messages
24
Can I use the IFCOUNT function with a cell has text and numbers? Or is there a better function to use.
Thanks
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
6589SCH 6598 6606 6612
6593A 6603 6594 6605 6602
6446CUT 6596 6601SCH 6608
6635 6641 6595 6604AD
6581 6600 6610
6616

I need to search for the text part after the numbers.
 
Upvote 0
I assume you mean COUNTIF.

For counting cells that end in SCH:

Excel Workbook
ABCDE
16589SCH659866066612
26593A6603659466056602
36446CUT65966601SCH6608
46635664165956604AD
5658166006610
66616
7
8
9
102
Sheet2


Is this what you need?
 
Upvote 0

Forum statistics

Threads
1,213,556
Messages
6,114,284
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top