@Alexiaiaa welcome to the KNIME forum. One simple example with a rule engine and a group by node can be found here:
There are more complex examples on the forum
https://forum.knime.com/search?q=Sum%20if%20Excel
You could also upload a sample file so we could give it a try