Summing number in one cell and code in another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pano - 20 Jan 2007 09:45 GMT

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

Reply to this Message

Bob Phillips - 20 Jan 2007 10:07 GMT

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

etc.

Signature

HTH

Bob Phillips

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

> Hi all, the problem is,
>
[quoted text clipped - 12 lines]
>
> thanks....

Reply to this Message

pano - 20 Jan 2007 10:38 GMT

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

> =SUMIF(E:E,E1,A:A)
>
[quoted text clipped - 23 lines]
> >
> > thanks....

Reply to this Message

pano - 20 Jan 2007 11:07 GMT

> Hmmmmm, very good but if E1 is empty (no Z7DN entered) it wont pick up
> the other Z7DN entrys below E1
[quoted text clipped - 26 lines]
> > >
> > > thanks....

Reply to this Message

pano - 20 Jan 2007 11:09 GMT

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

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

> Hmmmmm, very good but if E1 is empty (no Z7DN entered) it wont pick up
> the other Z7DN entrys below E1
[quoted text clipped - 26 lines]
> > >
> > > thanks....

Reply to this Message