sumproduct array

Dear MrExcel members, Thanks to the fabulous help of some of your members ( https://www.mrexcel.com/forum/excel-questions/1016579-index-match-multiple-criteria-great-than-post4879161.html#post4879161 ) I created the following SUMPRODUCT formula. The goal of the formula is to select results from...

I am using a sumproduct array formula to calculate the cost of a course and primarily have the raw data on sheet 'Data'. However, on sheet 'List', there is a growing list with the unique code of each student and whether the cost has already been paid. Replica of sheet 'List': Contact ID...

Say I have the following chart (See below) and I'm trying to sum the regions that have product overlap. What type of SumIf or SumProduct formula could I use to accomplish this task? <tbody> Product # Region 1 Region 2 Region 3 Region 4 Region 5 Region 6 Region 7 Region 8 Region 9 1...

<!--?xml version="1.0" encoding="UTF-8" standalone="no"?-->Hi I'm trying to track the response rates in various message threads and am having trouble writing the formula. I included a link to a sample data set as well as the sudo formula below. Any help would be GREATLY appreciated! Data Set...

Hi I am using an array function to sum values if any one of a criteria in my criteria array is a match (note it's an or not and AND requirement). The purpose being to roll up the values of multiple account identifiers into a more simplified list of accounts. The array...

Hi all, I need to do a SUMIF that is rather advanced compared to what I'm used to since it must compare arrays of different sizes (or match them sequentially). I can't find a way to post a screenshot nor mock file, so I hope below is understandable. I have an array A that consists of...