GetDotted Domains

Viewing Thread:
"Write me a formula"

The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.

Fri 21/05/04 at 17:43
Regular
"Spurs 1 - 0 Man Utd"
Posts: 5,235
Please.

In the column C, I need it to count how many with the letter 'B' in them there are.

Formula Please.
Fri 21/05/04 at 22:32
Regular
Posts: 3,941
mattributé wrote:
> Speed = Distance/time


ah, gcse's

Gotta love 'em :P
Fri 21/05/04 at 22:16
Regular
"tokyo police club"
Posts: 12,540
Speed = Distance/time
Fri 21/05/04 at 22:04
Regular
"Spurs 1 - 0 Man Utd"
Posts: 5,235
Cheers Timmy, sorted now.

Ta
Fri 21/05/04 at 18:19
Regular
"Twenty quid."
Posts: 11,452
=COUNTIF(C1:C99, "B")

Change the C1 and C99 to the values you need.
Fri 21/05/04 at 18:09
Regular
Posts: 15,579
You might have to use somthing like:

IF(c1)=B then + 1

That probably aint right, as i aint used excel in ages. but ts somthing like that i think.
Fri 21/05/04 at 17:49
Regular
"Spurs 1 - 0 Man Utd"
Posts: 5,235
Really badly phrased....

In column C, there are loads of different letters. I need a count to tell me how many of them have the letter 'B' in.

Excel.

Ta
Fri 21/05/04 at 17:49
Regular
"Teal'c"
Posts: 3,617
B=C♫Bﯽ
Fri 21/05/04 at 17:46
Regular
"The mighty GE90-115"
Posts: 5,344
...*post count booster

*confused
Fri 21/05/04 at 17:43
Regular
"Spurs 1 - 0 Man Utd"
Posts: 5,235
Please.

In the column C, I need it to count how many with the letter 'B' in them there are.

Formula Please.

Freeola & GetDotted are rated 5 Stars

Check out some of our customer reviews below:

Continue this excellent work...
Brilliant! As usual the careful and intuitive production that Freeola puts into everything it sets out to do, I am delighted.
Top-notch internet service
Excellent internet service and customer service. Top-notch in replying to my comments.
Duncan

View More Reviews

Need some help? Give us a call on 01376 55 60 60

Go to Support Centre

It appears you are using an old browser, as such, some parts of the Freeola and Getdotted site will not work as intended. Using the latest version of your browser, or another browser such as Google Chrome, Mozilla Firefox, or Opera will provide a better, safer browsing experience for you.