# True or False

#### DArinello

##### Board Regular
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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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.,

try this
Book2
ABCD
2ab0
3cc1
4dd1
Sheet1

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

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

Replies
2
Views
129
Replies
5
Views
515
Replies
1
Views
65
Replies
5
Views
171
Replies
5
Views
105

1,220,009
Messages
6,151,442
Members
451,028
Latest member
greekness1

### 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.

### Which adblocker are you using?

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

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