I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a completely separate table.
sum the values for D7:D999
If the text in G7:G999 equals the text in ‘sheet2’!B9 (a completely different cell in another sheet)
Note: The text in cell B9 changes which is why I can’t just write the text in B9 in the function.
I tried the following formula, but it didn’t work: