countif sum for column
i am using a workbook. in column e have various diffrent descriptions. in g i have amounts
need to list in k the column e sumarised (ie populate?) and L need a sum total
for example e5+e10+e12+e15+e20 is abigail and then need in K only abigail and L need eg5+g10+g12+g15+g20
this going down in k for all of the names in e
e could be 200 lines and K only 15 sumarised
|