Solved

Need help with excel

Posted on 2014-10-13
9
151 Views
Last Modified: 2014-10-14
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.
0
Comment
Question by:jodyreid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40377933
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.
0
 
LVL 81

Expert Comment

by:David Johnson, CD, MVP
ID: 40377935
is there a date inputted column?
0
 
LVL 2

Expert Comment

by:Glen Richmond
ID: 40379502
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?
0
Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

 

Author Comment

by:jodyreid
ID: 40379900
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
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40380157
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
0
 
LVL 2

Expert Comment

by:Glen Richmond
ID: 40380171
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
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40380223
Glen,

If you see the example, it does appear that each patient has their own sheet.  Dates are shown on row 3 (albeit, just whole numbers here) and they provide input (presumably hours) in rows 4:6 for various programs in which they participate (ex., 2 hours on Date "1" for program PT2011).  If they record any hours on a date, that is counted as a day of treatment.

So, any total greater than zero on row 7 indicates a day of treatment.  Counting the non-zero values in that row returns the number of days.

-Glenn
0
 

Author Closing Comment

by:jodyreid
ID: 40380314
This work great. Thank you for your time.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40380338
You're welcome.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision Office 365 tenants, synchronize your on-premise Active Directory, and implement Single Sign-On.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Mutiple Folder view (5 Folder view) 3 77
Lookup - Vlookup 9 59
Excel IF statement 4 28
Custom fill series 12 27
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

742 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question