MS Excel Question

Reply Subscribe

Thread Tools

Aug 24, 2007 | 11:38 AM

65 Fury Convert

Thread Starter

Drifting

Joined: Feb 2002

Posts: 2,637

Likes: 21

MS Excel Question

Looking at the screen shot I posted below, is there a formula that will tell me how many y's there are in column H?

Aug 24, 2007 | 12:18 PM

GIBSON6594

My Garage

Joined: Nov 2004

Posts: 13,386

Likes: 11

From: NY

Aug 24, 2007 | 12:20 PM

hornyleprechaun

Bent = #1

Joined: Dec 2001

Posts: 13,473

Likes: 25

From: Marietta, GA

Do you mean Y as in the conditional format you have to make the cell red?

Aug 24, 2007 | 12:20 PM

moeronn

is learning to moonwalk i

Joined: Feb 2004

Posts: 15,520

Likes: 3

From: SoCal

^^ I think you were correct before the edit.

I think there might be a formula, just a sec.

Aug 24, 2007 | 12:24 PM

moeronn

is learning to moonwalk i

Joined: Feb 2004

Posts: 15,520

Likes: 3

From: SoCal

Looks like COUNTIF should do the trick.

Try:
=COUNTIF(H2:H28,"y")

Aug 24, 2007 | 12:34 PM

65 Fury Convert

Thread Starter

Drifting

Joined: Feb 2002

Posts: 2,637

Likes: 21

^^^ that's it! It worked

Aug 24, 2007 | 12:35 PM

65 Fury Convert

Thread Starter

Drifting

Joined: Feb 2002

Posts: 2,637

Likes: 21

+1 for the help :wink:

Reply Subscribe

Related Topics

Thread

Thread Starter

Forum

Replies

Last Post

NavTool Video Interfaces for 3rd Gen MDX

navtool.com

3G MDX (2014-2020)

Jan 20, 2016 11:43 AM

NavTool Video Interfaces For TLX

navtool.com

5G TLX Audio, Bluetooth, Electronics & Navigation

Nov 16, 2015 08:30 PM

NavTool Video Interfaces for 1st Gen RDX

navtool.com

1G RDX Audio, Bluetooth, Electronics & Navigation

Sep 25, 2015 05:15 PM

'07 TL Rear Deck Speakers quit working

rboller

3G TL Audio, Bluetooth, Electronics & Navigation

Sep 23, 2015 02:49 PM

Reply Share

First
Prev
1 / 1
Next
Last