Re: Excel Question
Posted 12/21/2010 10:08:24 AM by skew
Posted by headoverheels
Can you give A and P a value? Such as at the bottom of the spreadsheet, put down that A = 1 and P = 0, and use those in place of the letters in the rows, so you can add up all the As at the end of the row (or column, however you have it set up) and that will give you the total # of absences.
If for my own records, yes but I have to submit the spreadsheet. The As and Ps must remain.
|