sum if criteria

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

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

SUM IF 3 Criteria

resolvedResolved · Urgent Priority · Version 2016

Sam has attended:
Excel Advanced course

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

I have received your file, thank you.
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.


 

Excel tip:

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


Server loaded in 0.07 secs.