That sounds pretty simple, thanks :) But I'm still having problems with it.
It's giving me an error message saying "You've entered too few arguments for
this function". What can I do to fix it?

"Paul Sheppard" wrote:


Tiff1618 Wrote:
Hey everyone,

I work at a school and I'm trying to update their attendance reports
from
hand written to excel, but I'm running into several problems. For one,
I need
it to be able to calculate how many "Ab"s (absents) there are in the
worksheet (for the individual student's attendance page). And THEN, I
need to
have the sum show up on a completely new document (for the overall
attendance
report). Is that possible? I've fooled around with data importing and
several
other things, but I'm just too new at this. If what I'm asking is
possible,
can anyone help me figure this out?

Thanks,
Tiffany

Hi Tiffany

In a cell not included in your range of data, you can count the Ab's
with this formula =COUNTIF(A1:A6,"Ab"), change the A1:A6 to suit your
range of data

To get the Ab's count to show on a different document, open that
document and the one with the Abs total, on the "different document go
to the cell where you want the abs total, type in the cell =, go to the
file with the abs total and click on the cell with the abs total, then
press enter, the total for abs will appear in the cell you typed = on
the different file


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399801