Planetarion Forums - Excel Formula

		Planetarion Forums > Non Planetarion Discussions > Programming and Discussion
Excel Formula

Reply

View First Unread

View First Unread

9 Mar 2003, 12:54	#1
Minty Who? Join Date: Sep 2001 Location: #Comfy Posts: 743	Excel Formula I am having trouble with an Excel Formula. I input these two characters into a column; "Y" for Yes "N" for No I want it to total the Y's and not the N's in the "Total" Cell I have tried IF Statements and all sorts. Can someone please help me out? Thank You __________________ #cnuts For all your homoerotic needs <Bobzy> Minty, you have a line for everything <Queen> MINTY ROCKS <Ice-Lady> minty is a odd boy <Game> Minty rocks <Queen> no minty..cos u rock <HobbieRogue4> Minty, you stone!

9 Mar 2003, 13:17	#2
Atamur Ngisne Join Date: Jul 2001 Location: right here Posts: 79	COUNTIF(<range>,"Y") __________________ down with signatures

9 Mar 2003, 18:11	#3
Minty Who? Join Date: Sep 2001 Location: #Comfy Posts: 743	ta i will try that when i get to work on Monday __________________ #cnuts For all your homoerotic needs <Bobzy> Minty, you have a line for everything <Queen> MINTY ROCKS <Ice-Lady> minty is a odd boy <Game> Minty rocks <Queen> no minty..cos u rock <HobbieRogue4> Minty, you stone!

Reply

« Previous Thread | Programming and Discussion | Next Thread »

All times are GMT +1. The time now is 20:59.