Summing number in one cell and code in another cell

P

pano

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....
 
B

Bob Phillips

=SUMIF(E:E,E1,A:A)

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
P

pano

Hmmmmm, very good but if E1 is empty (no Z7DN entered) it wont pick up
the other Z7DN entrys below E1
 
P

pano

Thanks Bob for putting me on the right track solved it with this

=SUMIF(e5:e40,"Z7DN",a5:a40)
 
Top