sum if criteria

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Forum home » Delegate support and help forum » » SUM IF 3 Criteria

# SUM IF 3 Criteria

Resolved · Urgent Priority · Version 2016

Sam has attended:

### SUM IF 3 Criteria

Hi guys,

I need a calculation to have 3 criteria for a SUMIF

I column "A" there a list of different components

In column "C" there is a list of different dates created

In column "G" there is a resolution dates.

I want the SUMIF to first find the component in A and then the correct date (by month) in column C and then find the resolution time and I want all the resolution dates matching that criteria added together.

I want the calculation to show for example all "Tracking issues" (Column A) that occur in February (Column C) and add the resolution dates that are in column G together.

Thanks,

Sam

### RE: SUM IF 3 Criteria

Hi Sam

Thank you for your forum query

There are a few solutions to your query but I'd like to see the file to test it

Please could you forward the file to info@stl-training.co.uk

Thank you

Kind regards
Wendy Canelas
Microsoft Office Trainer

### RE: SUM IF 3 Criteria

Hi Sam

It should be returned to you shortly

Please let me know if it helps

Kind regards

Wendy Canelas
Microsoft Office Trainer

Thu 16 Aug 2018: Automatically marked as resolved.

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips