Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
So I'm trying to get G4 to automatically find "Bananas" in all of C and for every time it finds a value it adds up the corresponding number in D.
=QUERY(C4:D, "select C,sum(D) where C <>'' group by C label sum(D)''")
=SUMIF(C$4:C, F4, D$4:D)
Required, but never shown