Using COUNTIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=COUNTIF(B2:BF2,attendance_type)

will count each type if you replace attendance_type with the code value.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs 1
countif from different worksheets 2
countif using other cell values for 'range' and 'criteria' 4
Using a COUNTIF statement with an AND operator 4
Question using countif 11
Questionnaire using Excel 3
COUNTIF - more than one condition 4
Countif question 7

Back
Top