Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel question

Thread Tools
 
Search this Thread
 
Old 15 December 2005, 12:25 PM
  #1  
druddle
Scooby Regular
Thread Starter
 
druddle's Avatar
 
Join Date: Mar 2001
Location: Berkshire
Posts: 5,528
Likes: 0
Received 0 Likes on 0 Posts
Default Excel question

Hello

I have a spreadsheet with a column for Y or N's. How can I easily get Excel to autosum the amount of Y's or N's in the column for me (i.e. 7 Y's and 3 N's, etc).

Dave
Old 15 December 2005, 01:12 PM
  #2  
ChefDude
Scooby Regular
 
ChefDude's Avatar
 
Join Date: Aug 2005
Posts: 4,290
Likes: 0
Received 0 Likes on 0 Posts
Default

="=" & COUNTIF(D2: D10,"=y") & " ys and " & COUNTIF(D2: D10,"=n") & " ns"
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
KAS35RSTI
Subaru
27
04 November 2021 07:12 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM



Quick Reply: Excel question



All times are GMT +1. The time now is 01:04 PM.