Counting how many days a person works.

  • Thread starter Thread starter Matlock
  • Start date Start date
M

Matlock

I have a scheduleing program we have been using with my buisness for years
and I am adapting to it, to make it more efficent.

I want it to be able to count how many days a person works, so we don't have
to count each day ourselvs.

Name Mon Tues Wed Thurs Fri Sat Sun
Angel 5.0 5.5 7.5 5.5 6.5 5.5

Each day already has a seperate formula in it (='Schedule Creator'!R5) to
copy from another Sheet.

Is there a formula that will count how many days a person is working, and
NOT how many formulas are in each cell.
 
Try COUNTIF:

=COUNTIF(B2:B8,">0")

I used B2:B8 to represent 7 cells (Mon - Sun). Adjust as needed.

Les
 
As I understand your question, you want to get the count of the elements
that are not equal to zero. Try

=SUMPRODUCT(--(B2:H2>0))

This will return the count (not the sum) of the items in B2:H2 that are
greater than zero.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top