May 12, 2016 · I have a range with positive values. I have requirement to add some amounts together based on a criteria and subtract amounts from it based on a criteria. Is this possible using …

Jul 17, 2012 · Hello, I have seen various posts that use something like: SUMPRODUCT(-- Could anyone explain what the -- is used for ? Many thanks

Aug 28, 2015 · I'm trying to do a sumifs or sumproduct with multiple criteria. I have lookups both vertically and horizontally and want the sum of the number that matches...

Mar 4, 2008 · When using SUMPRODUCT, you're basically comparing one or more ranges of cells to a value. When that "value" is text or any other non-numeric, the double-unary operator (--) converts the …

Jan 29, 2011 · I'm just learning sumproduct from different free online sources. I notice that the following two formulas produce same result. I wonder if there is any...

Nov 26, 2019 · I would be grateful for some assistance with this formula that I am struggling to write properly. Please see the excel table below. My aim is to rewrite the second part of the …

Sep 4, 2013 · So I only want to apply the SUMPRODUCT and SUM to those rows where all columns have an entry: In the below example, I only want sumproduct of rows 1, 2 and 4 and sum of A1, A2, …

Aug 16, 2024 · Hello all. I need a formula that sums an array of values based on certain criteria. The attached image is a simplified dataset for reference (the actual dataset is significantly larger). Logic …

Nov 19, 2007 · Does anyone know how to add Sumproduct and Min/Max functions? Using Excel 2010 I am looking for the minimum, or maximum number within a range while using the Sumproduct function...

Jan 3, 2018 · Anyway the problem I am having is around the SUMPRODUCT formula, What I am trying to do is a SUMPRODUCT based on 2 Specific Criteria (hence why I thought SUMIFS might be the …