True or False

[DArinello]

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?

 

[NBVC]

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]

try this

Book2
	A	B	C	D
1	Correct Answer	Given Answer	1 = True 0 = False
2	a	b	0
3	c	c	1
4	d	d	1
Sheet1

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

 

[hatman]

Something like this?

Book1
	A	B	C	D	E
1	x			TruemarkedTrue	4
2				FalsemarkedFalse	10
3				TrueMarkedFalse	6
4	x	x		FalseMarkedTrue	5
5
6		x
7
8	x
9		x
10
11
12	x
13	x
14	x	x
15		x
16
17
18
19	x
20	x	x
21	x	x
22		x
23
24		x
25	x
Sheet2