True or False

DArinello

Board Regular
Joined
Jul 26, 2005
Messages
63
Ok I am looking at results of a True or False test. Column A Is the correct answer and B is the given answer (1-25). As I have it now, An X represents True and a blank cell represents false. I want to create formulas to count: “True Marked True”, “True Marked False”, “False Marked True” and “False Marked False”. I tried making something using Countif but I couldn’t get it to work out. Anyone have any suggestions?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
This should give True marked False (if I understand correctly your criteria).

=Sumproduct(--($A$1:$A$25="X"),--($B$1:$B$25=""))

manipulate the criteria for the other counts.,
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
try this
Book2
ABCD
1Correct AnswerGiven Answer1 = True 0 = False
2ab0
3cc1
4dd1
Sheet1


formula in column c
=COUNTIF(A2,"="&B2)
 

hatman

Well-known Member
Joined
Apr 8, 2005
Messages
2,664
Something like this?
Book1
ABCDE
1xTruemarkedTrue4
2FalsemarkedFalse10
3TrueMarkedFalse6
4xxFalseMarkedTrue5
5
6x
7
8x
9x
10
11
12x
13x
14xx
15x
16
17
18
19x
20xx
21xx
22x
23
24x
25x
Sheet2
 

Watch MrExcel Video

Forum statistics

Threads
1,130,445
Messages
5,642,194
Members
417,259
Latest member
gtacw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top