SUM OF NUM VALUES WITH CONDITION

  • Thread starter adeel via OfficeKB.com
  • Start date
A

adeel via OfficeKB.com

I have large number of data as follows.....

For example...

Item Qty

Pen 10
Pencil 15
Rubber 20
Car 5
Motorcycle 50
Car 30
Train 100
Rubber 120

I want total number of Qty in one cell for every individual item.....eg. for
Car = 35, for Rubber = 140

I think my question is clear. please if some one can help me. i shall be
highly thankful
 

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

Dynamic Column Headings based on crosstab report 6
insert rows programmatically with formula change 5
Cannot sum values based on condition 1
Problem saving 1st form data from 2nd form 1
sum of row when duplicate entries of date, difference between 2 ta 1
Generation of random numbers and sum of those with a condition 11
Extracting a list of individual values created with sum of values 6
Sum the number of days between dates by Month 16

Top