Hello All - Is there a way to use the index match function with the sum function? I'm using index match but noticing its only pulling the 1st value in the data set (or array) instead of summing the value. For example, if I was searching rows for "Sales" and then columns for "salaries" and I have salaries listed multiple times, it would only pull the salary from the 1st time it was listed. Instead, I was hoping it would sum up all the values when "salaries" was listed.
Thank you very much in advance.
Thank you very much in advance.