Excel Question

Posted By Message

skew
LIF Adult

Member since 5/05

6794 total posts

Name:

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?

I know that I can count each A manually to determine the total but with over 100 students and 45 dates it would be a tedious task.

TIA

Posted 12/21/10 10:01 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

AngnShaun
Sisters

Member since 1/10

21015 total posts

Name:
Ang

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
 

headoverheels
s'il vous plaît

Member since 6/07

42079 total posts

Name:
LB

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
 

GoldenRod
10 years on LIF!

Member since 11/06

26792 total posts

Name:
Shawn

Re: Excel Question

countif(range,"A")

http://office.microsoft.com/en-us/excel-help/countif-HP005209029.aspx

Posted 12/21/10 10:07 AM
 

skew
LIF Adult

Member since 5/05

6794 total posts

Name:

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
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: Excel Question

You could use COUNTIF

For example:

=COUNTIF(B1:B3,"A")

would give you the number of As in the range B1 to B3

Posted 12/21/10 10:08 AM
 

neener1211
:-)

Member since 4/07

22952 total posts

Name:
J

Re: Excel Question

Highlight the column that you are looking in.
Click Edit
Then Find

When the Find box pops up, Enter A in the Find what field. Click Find all

It will tell you how many cells have A in it.

Repeat for P.

See if that works.

Posted 12/21/10 10:10 AM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

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
 

skew
LIF Adult

Member since 5/05

6794 total posts

Name:

Re: Excel Question

Thank you all for your quick help.

Barb, your formula works.
Chat Icon Chat Icon Chat Icon

Message edited 2010-12-21 10:18:19.193000.

Posted 12/21/10 10:17 AM
 

Egg
LIF Adolescent

Member since 5/09

627 total posts

Name:

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 ™