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 WesPCDr Your Own Question

WesPCDr
WesPCDr, Information Systems Manager
Category: Microsoft Office
Satisfied Customers: 1503
Experience:  Microsoft Office Specialist
21171802
Type Your Microsoft Office Question Here...
WesPCDr is online now
A new question is answered every 9 seconds

I would like to use sumifs function to sum various columns

Customer Question

I would like to use sumifs function to sum various columns of data (a large range)? Is this possible?
Submitted: 6 months ago.
Category: Microsoft Office
Expert:  WesPCDr replied 6 months ago.
Hello, I'm Wes, and I'll be assisting you today.
Expert:  WesPCDr replied 6 months ago.
The Excel function SUMIFS uses ranges SUMIFS(sum_range, criteria_range1, criteria1,[criteria_range2, criteria2],...)You can see a great example on how to use the function here:https://www.ablebits.com/office-addins-blog/2014/11/12/excel-sumifs-sumif-multiple-criteria/#sumifs-function