I've been struggling to get this to work SUMIFS or INDEX/MATCH, so I'll just explain the sheet setup.
On a Totals worksheet, I am creating the formula. In column A on this worksheet is an ID (which is derived from a UNIQUE formula, if that's relevant)
On a worksheet named Raw, the same ID exists in column C, and there can be many instances of it.
Also on this worksheet, I am looking only for instances of the word Historical that appear in column A
I then want to SUM column AF.
Both worksheets have header rows, so data starts in row 2.
This is in Excel 365
Greatly appreciate the help!
<3
On a Totals worksheet, I am creating the formula. In column A on this worksheet is an ID (which is derived from a UNIQUE formula, if that's relevant)
On a worksheet named Raw, the same ID exists in column C, and there can be many instances of it.
Also on this worksheet, I am looking only for instances of the word Historical that appear in column A
I then want to SUM column AF.
Both worksheets have header rows, so data starts in row 2.
This is in Excel 365
Greatly appreciate the help!
<3
