Please help

liteman24 · May 13th, 2002, 06:26 PM

I have a series of YES or NO questions in cells A1 to A3. In cells B1 to B3 have the answers to the questions, YES or NO. In cell B4 I want it to add the total number of YES answers. Can someone please give me the formula to use. I am sure that it is easy, but it's driving me nuts.

Thanks

[ This Message was edited by: liteman24 on 2002-05-13 17:27 ]

Yogi Anand · May 13th, 2002, 06:29 PM

Quote:

On 2002-05-13 17:26, liteman24 wrote:
I have a series of YES or NO questions in cells A1 to A3. In cells B1 to B3 have the answers to the questions, YES or NO. In cell B4 I want it to add the total number of YES answers. Can someone please give me the formula to use. I am sure that it is easy, but it's driving me nuts.

Thanks

[ This Message was edited by: liteman24 on 2002-05-13 17:27 ]

use

=Countif(A1:A3,"Yes")

Pinball · May 13th, 2002, 07:08 PM

Actually, I believe Yogi meant for you to use this formula, since the Yes and No answers are in B1 to B3.

=Countif(B1:B3,"Yes")

Didn't mean to correct you Yogi, but I just wanted to make sure that the poster had the solution to their post. I had to look twice at the way the question was posed just to make sure I read it right.

Yogi Anand · May 13th, 2002, 07:56 PM

Thanks Pinball -- You are right ... it should have read

=countif(b1:b3="Yes")

Regards!

liteman24 · May 18th, 2002, 12:58 PM

Got it...thanks a ton.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 06:26 PM	#1
liteman24 New Member Join Date: May 2002 Location: Houston Posts: 2	I have a series of YES or NO questions in cells A1 to A3. In cells B1 to B3 have the answers to the questions, YES or NO. In cell B4 I want it to add the total number of YES answers. Can someone please give me the formula to use. I am sure that it is easy, but it's driving me nuts. Thanks [ This Message was edited by: liteman24 on 2002-05-13 17:27 ]

May 13th, 2002, 07:08 PM	#3
Pinball Board Regular Join Date: Apr 2002 Posts: 107	Actually, I believe Yogi meant for you to use this formula, since the Yes and No answers are in B1 to B3. =Countif(B1:B3,"Yes") Didn't mean to correct you Yogi, but I just wanted to make sure that the poster had the solution to their post. I had to look twice at the way the question was posed just to make sure I read it right.

May 13th, 2002, 07:56 PM	#4
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Thanks Pinball -- You are right ... it should have read =countif(b1:b3="Yes") Regards!

May 18th, 2002, 12:58 PM	#5
liteman24 New Member Join Date: May 2002 Location: Houston Posts: 2	Got it...thanks a ton.