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

sum if criteria

ResolvedVersion 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:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.