Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Connect one-on-one with {0} who will answer your question

Related Microsoft Office Questions
I need help with excel do you have someone who can help me?
hi! i need help with excel do you have someone who can help me? … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
904 satisfied customers
I need to use sumproduct formula to link from one workbook
I need to use sumproduct formula to link from one workbook to another - used sumif but the problem is that after close the file it turns into values … read more
bbao
bbao
Freelance IT Consultant
141 satisfied customers
I need help with an excel formula that will conditionally
I need help with an excel formula that will conditionally format and highlight a cell on a different sheet to reflect the top 1/3, middle1/3 and bottom 1/3 rank through a VLOOKUP formula that the info… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
668 satisfied customers
How do I highlight cells that are used in multiple sumifs
How do I highlight cells that are used in multiple sumifs formulas on another sheet? I have one sheet with multiple sumifs that are tied to another sheet. I want the cells used in the formula result t… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
668 satisfied customers
I am looking for a formula (index match match I assume) that
I am looking for a formula (index match match I assume) that enters the sum of column H on another worksheet (let's call it Sheet2). For instance I want to match cell A3 (last name, first name) on She… read more
bbao
bbao
Freelance IT Consultant
141 satisfied customers
I attached an example. I have large amount of data and I
I attached an example. I have large amount of data and I need to add a total by each ID. I highlighted in yellow in what I need the result to be… read more
Richard
Richard
IT Manager
IT Manager, Consultant
15,034 satisfied customers
I have a worksheet and am trying to summarize information in
I have a worksheet and am trying to summarize information in another worksheet using the SUMIFS function. I am trying to add a column for DH if the entries occur between a date range. Here is the form… read more
Russell H.
Russell H.
Computer Systems Expert
13,645 satisfied customers
Here is the model Source Table: Column A (Name) Column
Here is the model Source Table: Column A (Name) Column B (Score) Gil Gibori 5 Carrie Gibori 3 Gil Gibori 8 Value table: Column A (Name) Column B (Sum) Gil Gibori 13 Carrie Gibori 3 Formula: = SUMIFS('… read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
1,078 satisfied customers
How can I use VLOOKUP?? to make calculations? Basically, I
How can I use VLOOKUP?? to make calculations? Basically, I have a column of 10000 car registration numbers with another column next to it with a CO2 emission rate. On a separate sheet (which I paste c… read more
Richard
Richard
IT Manager
IT Manager, Consultant
15,034 satisfied customers
I have the following formula: =SUMPRODUCT(SUMIF(INDIRECT("'"&$A$229:$A
I have the following formula: =SUMPRODUCT(SUMIF(INDIRECT("'"&$A$229:$A$242&"'!C3"),$B$230)) Which works fine, except I would like the "C3" reference to dynamically update to "C5" "C7" etc. as I carry … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
904 satisfied customers
First of all thanks help these last couple of days
First of all thanks for your help these last couple of days and secondly sorry to bother you on a Sunday. I now have two more issues and I believe they will be easy for you to figure out – no pressure… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
668 satisfied customers
I HAVE 2 COLUMNS WITH NUMBERS IN THEM SAY COLUMN A AND COLUMN
I HAVE 2 COLUMNS WITH NUMBERS IN THEM SAY COLUMN A AND COLUMN B, I NEED TO HIGHLIGHT ALL THE NUMBERS RED OR BOLD THEM THAT ARE IN COLUMN B.… read more
Josh
Josh
It Support Specialist
Associate Degree
7,373 satisfied customers
how would you highlight all the cells in a formula with one
how would you highlight all the cells in a formula with one color without going into eacg cell… read more
salah16
salah16
Half Master's Degree
10 satisfied customers
Im using Excel 2010 and a SUMIFS function to get my summarized
I'm using Excel 2010 and a SUMIFS function to get my summarized totals on my main report. Is there a way to create a drill down from the summarized total to show the rows of data that make it up. Exam… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
668 satisfied customers
Hello. How do I write a SUMIF formula that includes ranges
Hello. How do I write a SUMIF formula that includes ranges from multiple sheets? I have the following sheet names: Total Year 2013 Jan-13 Feb-13 Mar-13 Apr-13 On sheet "Total Year 2013" I have Names o… read more
Pete
Pete
Senior Engineer
Bachelor's Degree
3,081 satisfied customers
I need help! Id like a formula that checks the field in column
I need help! I'd like a formula that checks the field in column A for all those instances that match, and then --for matching rows-- adds up the numerical string that appears in column E. I haven't go… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
668 satisfied customers
Hi I have an excel sheet for which i created a sumifs formula
Hi I have an excel sheet for which i created a sumifs formula but i need this formula to be more specific in choosing the month i specify for. I have a column in my excel sheet showing the dates for e… read more
Richard
Richard
IT Manager
IT Manager, Consultant
15,034 satisfied customers
I need help finishing this formular: =SUMIF(Activity!$F$12:$F$15000,Budget!A7,Activity!$M$
I need help finishing this formular: =SUMIF(Activity!$F$12:$F$15000,Budget!A7,Activity!$M$12:$M$15000) the crieria should A7 is a date for example 01/15/2012 is a week ending date and i want it to sum… read more
NY Programmer
NY Programmer
Control Systems Engineer
Bachelor's Degree
522 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.

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:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

904 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

668 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

261 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

256 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Chris L.

Chris L.

Support Specialist

164 satisfied customers

Certified Expert with over 10 years experience.

< 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

Ask Your Question

x