Summing number in one cell and code in another cell

  • Thread starter Thread starter pano
  • Start date Start date
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....
 
=SUMIF(E:E,E1,A:A)

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Hmmmmm, very good but if E1 is empty (no Z7DN entered) it wont pick up
the other Z7DN entrys below E1
 
Thanks Bob for putting me on the right track solved it with this

=SUMIF(e5:e40,"Z7DN",a5:a40)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a sales quote sheet - sum totals by license type 1
Pivot table calculated field Count(field) / sum(field) 0
Excel 2013: AutoFilter and SUM() 1
Excel Subtracting multiple columns from another column 3
Looking formula that SUM values with specific value in neighboring colum 2
SUM cells in every other column IF adjacent cell equals a criteria??? 1
Show other cell if blank 5
SUM 2 COLumns values with common names in another columns 3

Back
Top