Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I am compiling a database and I'm having trouble figuring…

Customer Question
I am compiling a...

I am compiling a database and I'm having trouble figuring out what formula(s) i can use to reference two columns with month and year, and have it find a column with those time frames and return a value

Technician's Assistant: What programs and versions are you using?

excel 2010

Technician's Assistant: What is your ideal outcome? How can we solve this for you?

For one of the columns I need to sum a series of seperate columns that reference the same time frame.

Submitted: 8 months ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 5 minutes by:
9/20/2017
Programmer: Kris R, Computer Hardware Engineer replied 8 months ago
Kris R
Kris R, Computer Hardware Engineer
Category: Programming
Satisfied Customers: 4,547
Experience: IT Manager at Wood Group PSN
Verified

Hi
Sorry for the delay, we are busy and I've just got to your question.
How long has this been happening?
Thanks
Kris

Ask Your Own Programming Question
Customer reply replied 8 months ago
Just started building the database, its a new problem.
Programmer: Kris R, Computer Hardware Engineer replied 8 months ago

Using what? SQL or Access?

Ask Your Own Programming Question
Customer reply replied 8 months ago
I attached a snipet of the database I'm working on. I need a formula to sum the syndicated data under the red bar into the totals based on timeframe under the black bar
Programmer: Kris R, Computer Hardware Engineer replied 8 months ago

I am going to opt our for another expert to have a look, you will be emailed once they respond.

Ask Your Own Programming Question
Programmer: The-PC-Guy, Software Engineer replied 8 months ago
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 2,168
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript
Verified

give me a while to take a look

Ask Your Own Programming Question
Programmer: The-PC-Guy, Software Engineer replied 8 months ago

so can you explain what you want to sum, using rows and column values or address ranges

Ask Your Own Programming Question
Customer reply replied 8 months ago
For example...
YTD Dollars needs to sum Feb 2017 to Aug 2017 Dollars columns per row. Each row below the headers is indicative of an individual item.The dates will change every month to include the new month.
Programmer: The-PC-Guy, Software Engineer replied 8 months ago

what column letter is ytd dollars under

the column letters are across the top of the sheet,

and what columns are Feb 2017 - aug 2017 under

Ask Your Own Programming Question
Customer reply replied 8 months ago
The returned sum will need to be in column AJ, the data is found in columns DM through ER, but the columns will change every month as data is added so the columns aren't static.
Programmer: The-PC-Guy, Software Engineer replied 8 months ago

so you would want the result to go under all the rows in column AJ row 13.

I mean what is indicating that the summed column is FEB - Aug 2017, or DM - ER, or is it DM - DS that get included in the sum.

See here in is where the issue is is what indicates the data we need to sum.

And is it just 1 formula you are looking for.

Ask Your Own Programming Question
Customer reply replied 8 months ago
I would like the formula to reference the months listed in J4 through AZ5 as those will update based on the current date. But I'm not sure how to set up a reference for a span of time and multiple criteria.
Programmer: The-PC-Guy, Software Engineer replied 8 months ago

your ranges keep changing which is confusing me,

I think you mean the dates in row 5 for however many columns there are, staring in column AB?

Those dates indicate what you want to sum correct>

Ask Your Own Programming Question
Was this answer helpful?
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 2,168
2,168 Satisfied Customers
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,131 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

2,168 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
NEED EXCEL PROGRAMMING GOOD EXPERT WITH ONLINE CHAT
NEED EXCEL PROGRAMMING GOOD EXPERT WITH ONLINE CHAT… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a Word Document that I keep getting a Syntax Error on.
I have a Word Document that I keep getting a Syntax Error on. The formula is !Syntax Error, { for the formula, {=sum { * .05}}. I am simply trying to multiple a merged field by 5%.… read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
Help! My excel spreadsheet is locked all of the sudden.
Help! My excel spreadsheet is locked all of the sudden. I can't change, delete or add anything. I must has pushed something by accident.… read more
Ansh P.
Ansh P.
System Analyst
Bachelor\u0027s Degree
6,393 satisfied customers
Follow the direction to help me finish this excel
Attachment: 2011-10-12_070135_e07c1apartment.xlsx please follow the direction to help me finish this excel assignment: Enter a nested function in the Recommendation column to indicate Need to remodel … read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
in excel how do I convert polar back to rectangular
in excel how do I convert polar back to rectangular… read more
abhi_iitian
abhi_iitian
Bachelor's Degree
1,543 satisfied customers
I keep getting the following message when I try to close a
I keep getting the following message when I try to close a file in excel: “Cannot find ‘C:\ProgramFiles\MicrosoftOffice\Office11\Library\adaytum.xla'!AdaytumSheetClose which has been assigned to run e… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Excel Spreadsheet formula I need to compare the difference
Excel Spreadsheet formula: I need to compare the difference between two cells; where either or both cells could be a positive or negative number. I need the delta difference between the two cells. Sub… read more
Scott
Scott
MIT Graduate
Master\u0027s Degree
213 satisfied customers
I need to create a macro in excel to display the print preview
I need to create a macro in excel to display the print preview of the sheet. Thanks… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
How to link only text in MS Visio 2010 and not the entire shape?
Is there a way to link just the TEXT in Microsoft Visio 2010, I can only seem to link the entire shape.… read more
John
John
Software Engineer
509 satisfied customers
Excel 2016, I am using a lookup formula where I am comparing
I am using a lookup formula where I am comparing a value say in sheet B with an array in sheet A and returning the value in column 31... The formula is partially working. But the problem is that there are multiple matches for that row in one column and I need to sum them together and then return the sum total from column 31. … read more
George Sibiya
George Sibiya
PhD
282 satisfied customers
I have an excel question that would be best addressed if the
I have an excel question that would be best addressed if the programmer could see a copy of the excel file I'm working on. In the past I've used John D and would like to request him again. Thanks, Dav… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Excel 2011: I have a workbook containing a sheet with various
Excel 2011: I have a workbook containing a sheet with various columns, one of which (column F, F3:F2642) contains some blanks and some dates in the format of dd-mmm-yy. I need a formula to look down c… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a column that will only count, I need a sum. I cannot
I have a column that will only count, I need a sum. I cannot seem to be able to change from Count to Sum, I have tried autosum and it didn't work. HELP… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am a new user to excel 2007 and would like to sum the results
I am a new user to excel 2007 and would like to sum the results in a column if two other conditions are exist. Example: I have a customers name in column A; in column B I have the dates that they paid… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
have a projected budget for the year, by month, and individual
have a projected budget for the year, by month, and individual departmental budget worksheets. each department's sales figure is a percentage of the yearly budget on the projection sheet. as an exampl… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need a formula for the following Employees are paid to
I need a formula for the following: Employees are paid to attend up to 56 meetings/year at a rate of $10.00/meeting. I have two columns - one showing meetings attended each month (along with a running… read more
Christopher
Christopher
Bachelor's Degree
22 satisfied customers
HLOOKUP( AUG ,$C$1 $O$377,SUM(INDEX(K1 K377,17) (INDEX(K2 K377,21,FALSE)))) TH
=HLOOKUP("AUG",$C$1:$O$377,SUM(INDEX(K1:K377,17):(INDEX(K2:K377,21,FALSE)))) THIS FORMULA RETURNS #N/A USING EXCEL 2003 I AM TRYING TO USE HLOOKUP TO SUM A CERTAIN ROWS IN A COLUMN. AUG IS THE HEADING… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need to write an if/then statement as follows If reference
I need to write an if/then statement as follows: If reference cell isnumber, number otherwise If the reference cell is not a number, then sum the cells above starting at the cell immediately above the… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x