MrExcel Publishing
Your One Stop for Excel Tips & Solutions

counting correct answers


Posted by Craig Lynch on October 24, 2001 6:31 PM

Hello,

I want to calculate correct answers in a list, the data looks like:

winner joe john
galaxy galaxy fire
blitz bears blitz

I want to add the correct answers for each participant. In this example joe and john's totals would equal 1. How can I calculate this quickly?

Thanks.


Posted by Richard S on October 24, 2001 7:01 PM

Will the number of competitors change? (nt)

Posted by Craig Lynch on October 24, 2001 7:27 PM

Yes the competitors could change but only from week to week.

Posted by Aladin Akyurek on October 24, 2001 11:48 PM


In B2 enter: =SUMPRODUCT((LEN(B$4:B$5)>0)*($A$4:A$7=B$4:B$5)) [ copy this to C2 ]

where I assumed the sample data (including the labels "winner", "joe", and "john") to be in A3:C5.

Aladin

==========

Posted by Craig Lynch on October 25, 2001 7:53 AM

I tried entering that formula but it did not work. I get an

Is there some other way of calculating correct responses in a column?

Thanks.

Posted by Craig Lynch on October 25, 2001 7:54 AM

I tried entering that formula but it did not work. I tried adjusting the cell references but that did not help the formula does not give me a vaule.

Is there some other way of calculating correct responses in a column?

Thanks.

Posted by Aladin Akyurek on October 25, 2001 10:27 AM

The workbook is underway to you. (NT)