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
Solved

Need help with excel

Posted on 2014-10-13
9
149 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
  • 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 80

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
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

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

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

792 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