Excel Question
| Posted By | Message |
|---|---|
|
Excel Question I have a spreadsheet with student names and letters that correspond to attendance (A and P). Is there a formula that I can use to calculate the total number of absences (A) for each student? |
|
Posted 12/21/10 10:01 AM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
Re: Excel Question i dont think you can use a formula to do the calculation if there is no number in the cell... |
|
Posted 12/21/10 10:02 AM
|
|
|
Re: Excel Question 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. Message edited 2010-12-21 10:03:53.587000. |
|
Posted 12/21/10 10:03 AM
|
|
|
Re: Excel Question countif(range,"A") |
|
Posted 12/21/10 10:07 AM
|
|
|
Re: Excel Question 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. |
|
Posted 12/21/10 10:08 AM
|
|
|
Re: Excel Question You could use COUNTIF |
|
Posted 12/21/10 10:08 AM
|
|
|
Re: Excel Question Highlight the column that you are looking in. |
|
Posted 12/21/10 10:10 AM
|
|
|
Re: Excel Question You could also do a quick filter, which would bring up all of the absences & the total would be on the status bar at the bottom. |
|
Posted 12/21/10 10:12 AM
|
|
|
Re: Excel Question Thank you all for your quick help. Message edited 2010-12-21 10:18:19.193000. |
|
Posted 12/21/10 10:17 AM
|
|
|
Re: Excel Question Posted by nrthshgrl You could use COUNTIF For example: =COUNTIF(B1:B3,"A") would give you the number of As in the range B1 to B3 ditto. You can count pretty much anything in excel, whether it's text or a number. |
|
Posted 12/21/10 10:59 AM
|
|
Potentially Related Topics:
| Topic | Posted By | Started | Replies | Forum |
|---|---|---|---|---|
| Excel question... | igottabeme | 1/22/08 | 4 | Families Helping Families ™ |
| URGENT EXCEL QUESTION | kerrycec03 | 10/18/07 | 8 | Families Helping Families ™ |
| Excel Question | spooks | 8/22/07 | 1 | Families Helping Families ™ |
| Excel Question | spooks | 6/8/07 | 2 | Families Helping Families ™ |
| Excel masters - a question | SweetestOfPeas | 5/18/07 | 18 | Families Helping Families ™ |
| Dumb excel question | JenniferEver | 4/23/06 | 3 | Families Helping Families ™ |









