Summing number in one cell and code in another cell

Giganews Newsgroups
Subject: Summing number in one cell and code in another cell
Posted by:  pano (jenaw…@netspace.net.au)
Date: 20 Jan 2007

Hi all, the problem is,

A      B          C          D            E                F

10                                            Z7DN
3                                              ZAPO
4                                              ZBALL
5                                              Z7DN

I would like to add all occurrences of Z7DN in E so it adds up A

example  total Z7DN is 15 for the column A

total ZAPO =3  etc

thanks....

Replies