In using a conditional format I am able to change the cell formats
accordingly, but if I am only using basic formats to show the correct or
wrong answer to multiple choice questions then is there any way to count what
is right or wrong to the cells returning a percent correct mark? Maybe by
counting TRUE or FALSE? The answer in the cell is only ever going to be A, B,
C or D...

Regards,

Paul

=COUNTIF(A:A,TRUE)
=COUNTIF(A:A,FALSE)

"Paul Gooch" wrote:

> In using a conditional format I am able to change the cell formats
> accordingly, but if I am only using basic formats to show the correct or
> wrong answer to multiple choice questions then is there any way to count what
> is right or wrong to the cells returning a percent correct mark? Maybe by
> counting TRUE or FALSE? The answer in the cell is only ever going to be A, B,
> C or D...
>
> Regards,
>
> Paul

"Teethless mama" wrote:

> =COUNTIF(A:A,TRUE)
> =COUNTIF(A:A,FALSE)

Thanks for the quick reply, both formula's return 0. Based on my original
question, if I am using conditional formula's to achieve the result requires
a TRUE result to display the format selected. However the values within the
cell will only ever be A, B, C or D. Is there anyway to confirm the
conditional result into an actual result.

Paul

What is the conditional format you are using? In other words, are you
hardcoding each cell to Cell Value, or are you using the FORMULA is. If you
are using the formula is, I am assuming you have an answer key somewhere?
Assuming your questions are being answered in column A, rows 3 through 22,
and your answers are on a separate (possibly hidden) tab named Data, in
column A, rows 3 though 22:
=SUMPRODUCT(--(A3:A22=Data!A3:A22))
will give you the number correct, or true.
--
John C


"Paul Gooch" wrote:

>
>
> "Teethless mama" wrote:
>
> > =COUNTIF(A:A,TRUE)
> > =COUNTIF(A:A,FALSE)
>
> Thanks for the quick reply, both formula's return 0. Based on my original
> question, if I am using conditional formula's to achieve the result requires
> a TRUE result to display the format selected. However the values within the
> cell will only ever be A, B, C or D. Is there anyway to confirm the
> conditional result into an actual result.
>
> Paul

In other words, you want to count the correct/incorrect answers?

If that's the case then you need to setup a range of cells as the answer key
then you just compare the answers to the key.

Answer key in the range X1:X5 -

A
C
C
D
B

Users answers to questions in the range A1:A5 -

A
B
C
C
B

=SUMPRODUCT(--(A1:A5=X1:X5))

Result = 3 (correct answers)


--
Biff
Microsoft Excel MVP


"Paul Gooch" <(E-Mail Removed)> wrote in message
news:1167A3CE-7AF7-407E-8D68-(E-Mail Removed)...
>
>
> "Teethless mama" wrote:
>
>> =COUNTIF(A:A,TRUE)
>> =COUNTIF(A:A,FALSE)
>
> Thanks for the quick reply, both formula's return 0. Based on my original
> question, if I am using conditional formula's to achieve the result
> requires
> a TRUE result to display the format selected. However the values within
> the
> cell will only ever be A, B, C or D. Is there anyway to confirm the
> conditional result into an actual result.
>
> Paul

"John C" wrote:

> What is the conditional format you are using? In other words, are you
> hardcoding each cell to Cell Value, or are you using the FORMULA is. If you
> are using the formula is, I am assuming you have an answer key somewhere?
> Assuming your questions are being answered in column A, rows 3 through 22,
> and your answers are on a separate (possibly hidden) tab named Data, in
> column A, rows 3 though 22:
> =SUMPRODUCT(--(A3:A22=Data!A3:A22))
> will give you the number correct, or true.

John,

That is great thanks, I did not hard code but by doing that all worked
great, thanks ever so much...

Paul

"T. Valko" wrote:

> In other words, you want to count the correct/incorrect answers?
>
> If that's the case then you need to setup a range of cells as the answer key
> then you just compare the answers to the key.
>
> Answer key in the range X1:X5 -
>
> A
> C
> C
> D
> B
>
> Users answers to questions in the range A1:A5 -
>
> A
> B
> C
> C
> B
>
> =SUMPRODUCT(--(A1:A5=X1:X5))
>
> Result = 3 (correct answers)

Hi,

Thanks for that, as soon as I saw reference to "hardcoding" I knew there was
no other way, but the SUMPRODUCT worked great, I've never used that before.

Thanks to all who replied...

Paul

You're welcome!

--
Biff
Microsoft Excel MVP


"Paul Gooch" <(E-Mail Removed)> wrote in message
news:F6086B6D-193B-4E22-B52B-(E-Mail Removed)...
>
>
> "T. Valko" wrote:
>
>> In other words, you want to count the correct/incorrect answers?
>>
>> If that's the case then you need to setup a range of cells as the answer
>> key
>> then you just compare the answers to the key.
>>
>> Answer key in the range X1:X5 -
>>
>> A
>> C
>> C
>> D
>> B
>>
>> Users answers to questions in the range A1:A5 -
>>
>> A
>> B
>> C
>> C
>> B
>>
>> =SUMPRODUCT(--(A1:A5=X1:X5))
>>
>> Result = 3 (correct answers)
>
> Hi,
>
> Thanks for that, as soon as I saw reference to "hardcoding" I knew there
> was
> no other way, but the SUMPRODUCT worked great, I've never used that
> before.
>
> Thanks to all who replied...
>
> Paul