Programming

Related Programming Questions
I need to sum two separate ranges to meet a criteria in a
I need to sum two separate ranges to meet a criteria in a COUNTIFS FORMULA but can't seem to find the correct formula. Here is what I have right now: =COUNTIFS(\$U\$3:\$U\$90,"CERT",\$M\$3:\$M\$90,"OCT 1*",SU… read more
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
I have a file that has multiple rows and columns of text. I
I have a file that has multiple rows and columns of text. I want to count the occurrence of one or another specific strings of characters that are within other words - 3A or 7A or 7B… read more
Russell H.
Computer Technology Consultant
1,931 satisfied customers
I want to count numbers if a cell is within a range. Please
Attachment: 2012-01-22_233652_test.xlsx I want to count numbers if a cell is within a range. Please see attached excel sheet when I am able to attach it. By using a very long SUMIF I was able to get t… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
I am building a large complex Excel spreadsheet. I am using
I am building a large complex Excel spreadsheet. I am using the formula COUNTIF (range, "*") to count the number of cells in lists of music genres listed in cells above it. I would like to make the fo… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
Working in Excel 2010. I have a good knowledge of functions
Working in Excel 2010. I have a good knowledge of functions and a limited knowledge of arrays. I'm tyring to figure out a complex formula for the following: referencing Sheet1 and Sheet2. Where Sheet1… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
I need to count the number of times a particular word appears
I need to count the number of times a particular word appears in a table in excel.. IE, my range is C4 to I27 I tried COUNT function but it does not appear to work for text values, numbers only?… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
COUNTIF I have 3 columns, the first one contains one piece
COUNTIF: I have 3 columns, the first one contains one piece of data to determine a group, the second contains one piece of data to determine the state, the third contains a date. I would like to count… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
I have a spreadsheet that I created in 2007 using CountIfs.
I have a spreadsheet that I created in 2007 using CountIfs. Some people who will use my spreadsheet have lower versions of Excel which doesn't support Countifs function. Thus, I have written a VBA fun… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
i am trying to add up the # of staff i have working that day.
i am trying to add up the # XXXXX staff i have working that day. but use multiple conditions. for example i want it to count "10" as well as "10*" and "10c" and "10v" and "10-" and "13", "13*","13c","… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
I need to match dates with types of projects - heres a sample What
I need to match dates with types of projects - here's a sample What is the best formula to help me answer the following: Find how many times Project type 1 - total by week week 1 week 2 week3 week4 we… read more
Simit
Bachelor's Degree
1,993 satisfied customers
I am trying to count the number of times either x or y
I am trying to count the number of times either 'x' or 'y' appears in my excel data set. Can you suggest a formula that would do this for me. I'll need to count by row, and then separately, by column.… read more
Hirash Riyal
Higher Diploma In IT
174 satisfied customers
Im using excel as a scheduling tool. I am trying to ascertain
I'm using excel as a scheduling tool. I am trying to ascertain statistics based on this schedule and have found the countif function useful, but formatting it for the entire worksheet is very time con… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
Im having trouble using a wildcard in nested functions. this
I'm having trouble using a wildcard in nested functions. this formula returns results correctly: =SUM(IF('Data master'!A2:A5000=B3,IF('Data master'!K2:K5000="Client",1,0))) this one does not: =SUM(IF(… read more
abhi_iitian
Bachelor's Degree
1,543 satisfied customers
I have a list of values that I want to count a range of numbers
I have a list of values that I want to count a range of numbers in the column with one formula, not one for each value. Help!… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
This is an excel spreadsheet question; I want to count the
This is an excel spreadsheet question; I want to count the number of sales that have occurred FROM 10/01/2008 THROUGH 12/31/2008. The Sales column range is B2:B816 and each sale is labeled as "SLD" in… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
Hello. I want to count the number of rows in an Excel file
Hello. I want to count the number of rows in an Excel file in which at least one of multiple columns equals a certain value. In dBase, this would be a simple .or. command: COUNT FOR FIELD1='VALUE'.OR.… read more
John D
Bachelor Degree in Engineering
140 satisfied customers
What formula would I use to find the incidence of a number
What formula would I use to find the incidence of a number within a range of cells? For example, if I have a range of cells twenty rows by twenty columns, and there is a random placement of the number… read more
Techie_Ben
Software Engineer
Master's Degree
1,569 satisfied customers
I want this formula to sum only positive numbers, how do i
I want this formula to sum only positive numbers, how do i go about doing this? =IF(D4>=(E2:AN2),'Actual Score'!F4-1,'Actual Score'!F4-0)… read more
John D
Bachelor Degree in Engineering
140 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.

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

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.

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

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

Show MoreShow Less