I use the COUNTIF function to count the number of correct answers (words) for each test item, using this:
= COUNTIF(B5:B35,B1) where the 30 cell range is for the one-word answers in a column for one item, with each answer counted only if it matches the corresponding word in the key at the top of the column (beginning at B1) . When copied for each item (each vertical column), the range changes appropriately for each shift to the right, and the key word cell also shifts one cell to the right. This works fine for vertical comparisons.
However, when I try to us a similar formula for counting correct answers horizontally (in a row) for each student’s score (where each cell is compared to the corresponding cell in the key running across the top of the page, and only correct answers are to be counted), it seems to compare each answer with only the first cell in the key series.
Any idea for a formula that will give me scores (no of correct answers) for each student? Or is there a way that columns and rows can be exchanged (PivotTable doesn’t seem to do this)? I’d prefer not to exchange rows and columns.
Thanks
Bookmarks