Consider the following query:
=QUERY(A15:E861, "select B, sum(D) group by B")
This works for rows with col B's that have the SAME description eg.
1 | abc | n | 10 2 | abc | n | 10 3 | cba | n | 10
Will result in
abc | 20 cba | 10
But let's say I have
1 | abc-#ref123 some description | n | 10 2 | abc-#ref456 another description | n | 10 3 | cba-#ref889 last description | n | 10
And I want to ignore the "
$refxxx description". How do I go about doing this?