asked on

Need help with excel

I have a excel work sheet that has data inputted most days for the month. I need a VB Script to add up the days that each person has had data inputted. I don't need the amount just the total od days each person had data inputted. Is this possible.
Thank you.

Professor J

when it is an excel question, please select Microsoft Excel in the topic category.

i wouldn't understand your question, without seeing a dummy sample file.

David Johnson, CD

is there a date inputted column?

Glen Richmond

I presume you have a input by col and a date col is this correct and you want to list distinct days and distinct users as a volume.. i.e.

1/10/2014 Glen
2/10/2014 Jody
3/10/2014 Glen

Glen =2
Jody =1

Is this what you are after?

Jody Reid

ASKER

Yes. I have uploaded a sample of the spreadsheet I have . This is close to what I have and I need only the total days this person was at the center. Thank you for your help with this.
Days-at-Center.xlsx

Glenn Ray

You do not need a VB Script (VBA) to calculate this. In cell E9, enter:
=COUNTIF(B7:F7,">0")

It will show the count of total values that is greater than zero (i.e., the number of days there is entry).

Regards,
-Glenn

Glen Richmond

from your example how do you come up with the Answwer 2?
you need to explain the issue more inorder to be able to come up with a solution.

Ie.
Each pactient has thier own sheet or grid of data.
on this example B2 is the name of the patient.
range a3:f7 is the data for the patient.
you need to sum row 4 (ignoring col1) for for each date column, added in row 3 (at the moment only 5 date columns)

Cheers

ASKER CERTIFIED SOLUTION

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jody Reid

ASKER

This work great. Thank you for your time.

Glenn Ray

You're welcome.