Question about Microsoft Excel for PC

1 Answer

Using * in a EXCEL functions

For example in cell M2 there is the wording Quick Brown Fox Jumps Over The Lazy Dogs

Using COUNTIF(M2,="*FOX*"") produces a count of 1

Using IF(M2="*FOX*","YES","NO") produces NO as the result - I would have expect YES.

I was under impression that using *either side* of characters would work for IF function.

Your comments would be appreciated - thank you

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 409 Answers

Correction to your code
=COUNTIF(M2,"*Fox*")

version of formula that will work
=IF(COUNTIF(M2,"*FOX*"),"yes","no")

Posted on Jan 08, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Prepositions


No, there is only one.

Mar 23, 2014 | Computers & Internet

1 Answer

How do do a test page


The quick brown fox jumped over the lazy dog.

Dec 20, 2013 | Nakajima Office Equipment & Supplies

1 Answer

Typing master practice


The quick brown fox jumped over the lazy dog.

Nov 11, 2013 | Computers & Internet

1 Answer

How to type fast


learn where the keys are and practice typing this ;"THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG". it uses every letter

Aug 16, 2011 | Computers & Internet

2 Answers

I like to have a typing skill to speed up my ability to type as much as possible


Hello,
You will type A BROWN FOX QUICK JUMPS OVER THE LAZY DOG.

HOPE IT WILL HELP YOU.

Jan 06, 2011 | Computers & Internet

2 Answers

School Truancy Report Formula


For the same exemple you can try this:
=COUNTIF(A1:A4,"=George Washington School")

Apr 03, 2009 | Microsoft Excel for PC

2 Answers

Source code for word count


Haha, i wrote one of thee a while ago for a competition. You need to us e the char at function mate :D
Inside a for loop
Ill havea look for you though :D

Sep 09, 2008 | ArcMedia JavaScript Source Code 3000 Pro...

3 Answers

Excel Formula


Lets say your data (cars) is in range "D1:D21".

You need to know how many are Dodge and Ford in cell E1.

=COUNTIF(D1:D21,"Dodge") + COUNTIF(D1:D21,"Ford)

Hope this helps.

Apr 22, 2008 | Microsoft Excel for PC

1 Answer

Multiple letters in each cell, want to add the letters and tally how many of each


Use the =COUNTIF function


For example if column a has the letters in it:


=COUNTIF(a1:a100,"a")
or
@COUNTIF(a1..a100,"a")


This will count all of the letter 'a' s in
column a from row 1 to row 100.

Mike

Oct 31, 2007 | Microsoft Excel for PC

1 Answer

Excel


See if this is possible using the COUNTIF formula in Excel. Example: My range is A1:A20. Lowest number being 1 and highest number being 20. To see how many are less than 10 I'd use: =COUNTIF(A1:A20,"<=10") To see how many are less than 20 but greater than 10 is a little different. (And this might be the crazy way). I do this: =SUM(COUNTIF(A1:A300,"<=20") - COUNTIF(A1:A300,"<=10")) Try this and see if it works for you. It seemed to work fine for me.

Sep 23, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

263 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18355 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...