View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phillip Swanepoel Phillip Swanepoel is offline
external usenet poster
 
Posts: 21
Default 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