How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Ameen Khan Your Own Question
Ameen Khan
Ameen Khan,
Category: Programming
Satisfied Customers: 10876
Experience:  Senior IT Support Specialist at Brookfield Asset Management
Type Your Programming Question Here...
Ameen Khan is online now

I am trying to find out what formula I need to use in Excel

This answer was rated:

Hi - I am trying to find out what formula I need to use in Excel to return results based on a number of criterias
JA: When did you last update Excel?
Customer: I am using Excel 2016
JA: What have you tried so far with your Excel?
Customer: I need to understand what formula i need to use I think it is a combination of a VLookup and a SUMIF
JA: Anything else you want the Software Expert to know before I connect you?
Customer: no
Customer: replied 6 months ago.
I am trying to do a lookup from one sheet that looks to another and thre criteria I am trying to get to isLookup a product code and a month in the resuts sheet - If there is a value in the sheet for the product and the month then return the sum of the result

Hi! My name is Ameen and I'll be assisting you. Secure Remote Assistance is NOT REQUIRED (But Helpful)

I am sorry you are having this concern, I will do my best to help you today.

To answer your question ->

​Follow the steps from this link below to perform the lookup functions


Let me know if you have any follow up questions. I am here to help you.

Ameen Khan and 6 other Programming Specialists are ready to help you
Customer: replied 6 months ago.
Is it easier for you to connect to my PC?
Customer: replied 6 months ago.
Hello ?
Customer: replied 6 months ago.
Is there anyone there? I have accepted the request and heard nothing since?
Customer: replied 6 months ago.
Customer: replied 6 months ago.
Please cancel this request

Kindly open this link on your device and Join -