I am trying to find out how i can go about it. Please refer to the attached image. P is Present and A is absent. I know how to use COUNTIF function but i want to know if what i want is possible.
See solution in other versions of Excel:. Question: In Microsoft Excel 2011 for Mac, my Excel spreadsheet has numbers for both rows and columns. How do I change the column headings back to letters such as A, B, C, D? Answer: Traditionally, column headings are represented by letters such as A, B, C, D. If your spreadsheet shows the columns as numbers, you can change the headings back to letters with a few easy steps. In the example below, the column headings are numbered 1, 2, 3, 4 instead of the traditional A, B, C, D values that you normally see in Excel. When the column headings are numeric values, R1C1 reference style is being displayed in the spreadsheet.
To change the column headings to letters, select Preferences. Under the Excel menu.
![For For](/uploads/1/2/5/5/125581525/906914128.png)
When the Excel Preferences window appears, click on the General option under Authoring. When the General window appears, uncheck the option called ' Use R1C1 reference style' and click on the OK button. Now when you return to your spreadsheet, the column headings should be letters (A, B, C, D) instead of numbers (1, 2, 3, 4).