In work with excel i use a lot of “quick sum” function - it is automatic sum of selected area in right bottom corner. i would use it a lot in knime in table view - what do you think?
With the Math Formula or Column Expression node you should be able to perform these aggregations. It might be necessary to filter first for the relevant data you want to aggregate.
If you’re coming from the Microsoft Excel world you might want to give our free eBook a try: https://www.knime.com/knimepress/from-excel-to-knime