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.
Print Post      Close Window