Sum Cells with SUMPRODUCT
© Ted French
In addition to counting cells that meet multiple conditions set by the user, SUMPRODUCT can also sum the contents of those cells.
Even though Excel has the better known SUMIF and SUMIFS functions to add up values that meet one or more conditions, SUMPRODUCT still has its uses.
One such use is summing the data in cells that fall between two values.
For more information read this short tutorial on how to Sum Cells Between Two Values with SUMPRODUCT.
Related Tutorials
Comments
No comments yet. Leave a Comment