How do i add a column of values based on another column in excel

G

Guest

I am doing up a minor budget scheme and I am a little stuck on this one.

I have 2 columns. First column is an amount and the second column has
different they type of amount of the first column.

eg:
Cell A1 = 700
Cell A2 = 200
Cell A3 = 150

Cell B1 = "Amount 1"
Cell B2 = "Amount 2"
Cell B3 = "Amount 1"

What I am looking for is a way to add up the values of Column A by the type
defined in Column B. Could you help?

Thanks
 

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

Augmenting an integer in a column to reflect duplicates in another 23
How can I add the values based the color of font and the date 1
How to add data from cells based on different criterias? 2
Excel Concatenate cell data from column based on criteria in adjacent column 2
Change formulas in a column based on a selection. 3
How do I count # of cells with same value other column? 4
Two Calculations in one column 4
conditional format on column based on cell value 2

Top