| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding up a particular character in a row
I have an attendance list and I need to have my final column telling me every
time the letter "A" (for absent) hits on that row. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding up a particular character in a row
On May 9, 10:19 am, "rkalabokes" <u34051@uwe wrote:
I have an attendance list and I need to have my final column telling me every time the letter "A" (for absent) hits on that row. Try this: =countif(J2:J99,"A") change "J2:J99" to the correct range for your spreadsheet. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding up a particular character in a row
Thank you I will test this out
Try this: =countif(J2:J99,"A") change "J2:J99" to the correct range for your spreadsheet. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding up a particular character in a row
that (of course) did end up working. thank you very much! it was much
appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
| Adding a character to a defined name with a formula or macro | Excel Discussion (Misc queries) | |||
| Adding overscore to character in a cell in an Excell spreadsheet | Excel Discussion (Misc queries) | |||
| Adding a character to the beginning and end of txt in a cell | Excel Worksheet Functions | |||
Linear Mode
