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 have this commission form that I am trying to fix the
I have this commission form that I am trying to fix the formulas on, but not sure what I am supposed to do. Here is what it is supposed to do: The Agent Commission Split is determined either by % or a… read more
Andrew Taylor
Andrew Taylor
IT System Administrator
Bachelor of Computer Science
2,195 satisfied customers
Have a row with 60 columns. Need to conditionally format
have a row with 60 columns. Need to conditionally format cells such that if the sum of 7 consecutive cells in the row >86 and or if the COUNT of any 30 consecutive cells >24 the cell goes red … read more
Nilesh
Nilesh
592 satisfied customers
When I am using Excel AutoSum feature, the sum result comes
When I am using Excel AutoSum feature, the sum result comes up as zero, or it will sum the row instead of the column or some other error. I am running Catalina on a MacBook Pro and am wondering if the… read more
Tech Shru
Tech Shru
Bachelor Engineering
1,511 satisfied customers
Do you provide formulas for excel? I am unsure but version
I don't think this is the support I need; I am looking to submit a formula request for excel from a sheet I currently have setup and have someone provide me the correct formula. Is this what you provide? … read more
Jason Jones
Jason Jones
Computer Technician
26,209 satisfied customers
I need help creating a pivot table in Excel 2011. I'm not
Hi I need help creating a pivot table in Excel 2011 … read more
Manas
Manas
340 satisfied customers
Thanks for your help. That worked, except now for some
Hello again, thanks for your help. That worked, except now for some reason columns T and Z are not calculating. I will need to add this formula set to each monthly sheet and then my new question is ho… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
830 satisfied customers
I CREATED MANY CHECKBOOKS IN MICROSOFT WORD 2003 TABLE
I CREATED MANY CHECKBOOKS IN MICROSOFT WORD 2003 TABLE FORMAT AND HAVE INSERTED FORMULAS IN ONE COLUMN TO EITHER ADD OR SUBTRACT, GIVE A SUBTOTAL AFTER EACH ENTRY AND A GRAND TOTAL AT THE END. … read more
Bing
Bing
Freelance IT Consultant
1,268 satisfied customers
I have a spreadsheet downloaded from my bank statement and
I have a spreadsheet downloaded from my bank statement and have used a formula =(sumproduct(--isnumber(search(Search_box,A1)))>0) as conditional format with a colour highlighted to show the entries… read more
Bing
Bing
Freelance IT Consultant
1,268 satisfied customers
How do I add a Summary formula field at the bottom of a
How do I add a Summary formula field at the bottom of a column in a Microsoft Word table? … read more
Bing
Bing
Freelance IT Consultant
1,268 satisfied customers
I had a great experience a few days ago with this resource-I
Hi-I had a great experience a few days ago with this resource-I have another question on the same worksheet-would it be possible to send my document and question for additional support? Is that $39 fo… read more
Russell H.
Russell H.
Computer/Electronics Consultant
Vocational, Technical or Trade Scho
2,431 satisfied customers
Do you do excel formulas? excel 2007, pc yes all updated, no
Do you do excel formulas ? JA: What's the make and model of your computer? And what version of Excel are you using? Customer: excel 2007 JA: Have you installed any updates recently? Customer: pc yes a… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
830 satisfied customers
I have an excel formula that has a value (FSC) that changes
Hi, I have an excel formula that has a value (FSC) that changes week to week. how do i adjust this formula to keep prior weeks results from changing because of the new value (this week's). last week t… read more
Steve
Steve
Consultant
Bachelor
297 satisfied customers
I am looking to create a spreadsheet where I can input a
I am looking to create a spreadsheet where I can input a real estate agents gross commission income (GCI) for the year and it will calculate their net based on a sliding scale. For example: -50% of GC… read more
Russell H.
Russell H.
Computer/Electronics Consultant
Vocational, Technical or Trade Scho
2,431 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/Electronics Consultant
Vocational, Technical or Trade Scho
2,431 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,190 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
1,250 satisfied customers
I need a formula that will allow me to calculate data from
I need a formula that will allow me to calculate data from columns into number of daily visits by staff to clients seen per day. I have a column with date of visit, another column with staff name (e.g… read more
Zabo04
Zabo04
Master\u0027s Student
Master's Degree
173 satisfied customers
I need help with getting TY vs LY % change in sales within
I need help with getting TY vs LY % change in sales within powertpivot. no formula is working.… read more
TechExpert
TechExpert
Master's Degree
185 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:

Jess M.

Jess M.

Computer Support Specialist

1,250 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

830 satisfied customers

20 years experience providing remote computer support

Kamil Anwar

Kamil Anwar

Office Specialist

473 satisfied customers

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

Shefin

Shefin

Microsoft Office Specialist

468 satisfied customers

Working as Tech support specialist with a world famous computer manufacturer

James K.

James K.

Consultant

375 satisfied customers

Technical Director of IT Company

Miro

Miro

Computer Support Specialist

211 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

177 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