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

match criteria find

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Match 2 criteria to find a third and add together

Match 2 criteria to find a third and add together

ResolvedVersion 2016

Sam has attended:
Excel Advanced course

Match 2 criteria to find a third and add together

Hi,

I need a formula to find match two criteria and add the numbers that match these criteria together.

e.g if I am looking in a table to matc "user access issues" in column a and "major" in column c and they have three numbers that relate to those 2 specific criteria in column d i want these three numbers added together.

So in summary I need to match 2 criteria to look up certain numbers that relate to these criteria in another column and I want these added together.

Hope that makes sense. Willing to send the excel workbook if needed.

Thanks,

Sam

RE: Match 2 criteria to find a third and add together

Hi Sam,

Yes I better have a look at your worksheet.

Please send it to:

info@microsofttraining.net

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

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.71 secs.