# Function query

#### tintostu

##### New Member
I have a sheet where i have Mon, Tues, wed/etc.

On these days I have a list that incudes a number could be anything from 1-100.

So if someone enters say Monday 20, Tuesday 56, Wednesday 9, Thursday 0, Friday 0, Saturday 2, Sunday 23

How to a get a field at the end of this to say this person has worked for x amount of days .

In this case it would be 5 days as the ones that say 0 the person has not worked that day.

So in short how to you add the numbers up, what ever the number as 1 and then **** all these up to work out how many days that person was in for

Does this make sense?

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
If your numbers are in a range you can use countif, such as
=COUNTIF(D1:D5,">0")

Replies
2
Views
224
Replies
2
Views
161
Replies
4
Views
271
Replies
3
Views
250
Replies
4
Views
93

1,196,409
Messages
6,015,104
Members
441,870
Latest member
kojack

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back