Excel (Need a formula)

H

HeatherV

I need a formula that will enable me to count how many of each product there
is. For example in one column there could be five different products appear
several times and in the column next to it I have the amount of product. I
want the formula to look up the two columns and give me the total of each
product.
 
M

Mattlynn via OfficeKB.com

A pivot table could do this a lot easier. It would count and also add any
values (Revenue) to each of the different products
The count can be treated as such that it will count how manty times the
product appears, or sum together if eachg product line was a number sold.

I.e
Product Quantity ££

Apples 52 15.00
Orange 62 76.00

Etc etc

Matt
 
S

ShaneDevenshire

Hi,

Suppose your data is in A1:B1000

Then in column D list each product once starting in D1. You can use the
Advanced Filter, Unique Records command to do that for you.
In cell E1 enter the formula
=COUNTIF(A$1:A$1000,D1)
and fill it down as far as necessary
In cell F1 enter the formula
=SUIF(A$1:A$1000,D1,B$1:B$1000)
 

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

Custom toolbar button for search and replace 1
Mail Merge Help 1
Setting column width in a table with a macro is not working 0
Copy addition formula of non-consecutive horizontal cells 2
Consolidation Table from Different Excel Tabs with Different Format 1
I need help with a table formula/mass editting 2
Trying to create custom labels from an csv file + Need items numerically counted out 0
Installing/purchasing office 2021 plus. A licence question. 0

Top