Is there a way to search for matches and then sum other cells pertaining to those matched? Let's say I have rows and each has a column of classes (with AC, DC, DM) and a column of quantity. Is there a way to find all rows that = AC and add up all the quantities for AC?
AC 10
DC 10
DC 10
DM 10
AC 10
So basically, I want something to get the results AC=20, DC= 20, DM=10...
Thanks in advance.
AC 10
DC 10
DC 10
DM 10
AC 10
So basically, I want something to get the results AC=20, DC= 20, DM=10...
Thanks in advance.