ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   countif sum for column (https://www.excelbanter.com/excel-programming/454606-countif-sum-column.html)

Phillip Swanepoel

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


All times are GMT +1. The time now is 08:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com