Using COUNTIF
 

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.

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.


"Mouldydc" wrote:

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.

=COUNTIF(B2:BF2,attendance_type)

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

--
HTH

Bob Phillips

"Mouldydc" wrote in message
...
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.