Using COUNTIF

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mouldydc - 16 Aug 2005 12:31 GMT

Hi,

Hi I'm using Excel to keep an attendance sheet. I need to collate the days
that people are in the office, working at home, or out of the office on
business, into one figure.

The data is stored in B2 - BF (eg).
Advice would be great! I have a fairly old version of excel.

Reply to this Message

Duke Carey - 16 Aug 2005 12:43 GMT

Offering solutions to you would be sooo much easier if you provided some
details. What's the layout of your sheet? How do you denote where people are
working? Is it by a code, or entries in different columns, or some other
means? Help us help you by giving us something to work with.

> Hi,
>
[quoted text clipped - 4 lines]
> The data is stored in B2 - BF (eg).
> Advice would be great! I have a fairly old version of excel.

Reply to this Message

Bob Phillips - 16 Aug 2005 13:20 GMT

=COUNTIF(B2:BF2,attendance_type)

will count each type if you replace attendance_type with the code value.

Signature

HTH

Bob Phillips

> Hi,
>
[quoted text clipped - 4 lines]
> The data is stored in B2 - BF (eg).
> Advice would be great! I have a fairly old version of excel.

Reply to this Message