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.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I have an Excel Spreadsheet where I am trying to use a

Customer Question

I have an Excel Spreadsheet where I am trying to use a formula that will use the Offset function as the Range in the SumIfs function. The Offset function will need to pass the Column Value from a cell. There will be multiple conditions and criteria.  SumIfs formula should run significantly faster than SumProduct so I would like to get this working.

I have loaded a Test file which has the formulas I need working in blue.

Submitted: 2 years ago.
Category: Programming
Expert:  The-PC-Guy replied 2 years ago.
so what exactly are you looking to do, I am still not following
Customer: replied 2 years ago.
Can you close this? I saw that it is possible to do what I wanted