Jul 18 2017
07:09 AM
- last edited on
Jul 25 2018
09:49 AM
by
TechCommunityAP
Jul 18 2017
07:09 AM
- last edited on
Jul 25 2018
09:49 AM
by
TechCommunityAP
This was a mistaken second upload.
Jul 19 2017 01:33 AM - edited Jul 19 2017 01:40 AM
Hi,
sounds like that it could be a case for multiple conditions with SUMPRODUCT. Please see this article for a tutorial: https://www.ablebits.com/office-addins-blog/2016/08/24/excel-sumproduct-function-formula-examples/
Additional note: I have just seen, that this question is a duplicate one of this one https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Need-help-with-very-complex-formula-co... and is already solved.
Best,
Mourad
Jul 19 2017 01:43 AM - edited Jul 19 2017 01:50 AM
perhaps can be addressed by using pivot table first then using sum/sumif function after the data was filtered using slicers. see attached sample.