Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,

Get an Answer ASAP!

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.

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a programmerLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Programming Questions

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

I have a spread sheet that has line item costs that are

I have a spread sheet that has line item costs that are categorized 1,2,3 or 4. I want to summarize costs by category. How?… read more

I want to essentially find all money that was made in the different

I want to essentially find all money that was made in the different quarters over two columns and the result from that would be the sum also over 2 columns. Any ideas?… read more

I need a formula to sum numbers in a row until they reach a

I need a formula to sum numbers in a row until they reach a value and then return the column example 25,35,18,22,51,14 sum numbers until reach 72 and return column this would return column 3… read more

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

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

Trying to get a TOTAL -- of cell G3 to G9 if the value in the

Trying to get a TOTAL -- of cell G3 to G9 if the value in the cell is greater than zero and not blank. At the same time -- any cell that is greater than zero - I need to add 1 to total (not to the cel… read more

In Excel 2007. I need to find the sum of all values in a single

In Excel 2007. I need to find the sum of all values in a single column that have one of two corresponding values in another column and return that sum to a single cell.… read more

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

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

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

I need a formula to sum the numerical values that correspond

I need a formula to sum the numerical values that correspond to each month and year . Column A has a day/month/year in ascending order beginning with A4. For every two dates there a calculated percent… read more

I use Excel 2003 and currently have this formula SUM(IF($A$16 $

I use Excel 2003 and currently have this formula: =SUM(IF($A$16:$A$9999="BH",IF(AH16:AH9999>=500,1,0),0)) But I want to use this inconjuction with the SUBTOTAL function. Can you help me on this for… read more

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

I have an excel spread sheet that I am building and I have

I have an excel spread sheet that I am building and I have a cell that I plug in the date (first day of the year) another cell that pulls the current date from the system clock and a third cell that d… read more

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

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

How do you calculate an annual IRR with Excel with different

How do you calculate an annual IRR with Excel with different payment periods eg quarterly or monthly?… read more

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.

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.

...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.

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.

New York

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

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!!!!

Los 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.

Hesperia, CA

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

Kernersville, 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.

Woodstock, 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.

Elkton, Maryland

< Previous | Next >

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

Computer Software Engineer

7,175 satisfied customers

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

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

Computer Software Engineer

950 satisfied customers

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

ehabtutor

Computer Software Engineer

936 satisfied customers

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

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

Software Engineer

2,236 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

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.