I need to write a formula (assuming it is sumifs) to sum market values for a certain account number holding any of a list of numerous tickers.
=SUMIFS($H$3:$H$7,$G$3:$G$7,G3,$I$3:$I$7,K3:K6)
I have used this formlua (referring to image above), but it is not working the way I expected it to (returns a value of $9,000, should be $10,000). I am guessing it's related to attempting to use the list of tickers as a criteria, but thought that making it an array would solve that.
Hugely appreciated to anyone who can help