98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » SUM IF 3 Criteria
SUM IF 3 Criteria
Resolved · 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.
Training information:
See also:
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create and delete bordersTo put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range. |