SUMIFS function


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. 

For example, 

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: 


By: Dana

Leave a Reply

Your email address will not be published. Required fields are marked *