# Adding One Column Based on Criteria in Another

1. ## Adding One Column Based on Criteria in Another

Hi.

Bit of a newbie to Excel, so would appreciate some help with a couple of formula's, I think using "COUNTIF"

In column C2:C100 I have either A, B or C, and in column L2:L100 I have different amounts of money.

How would I add the corresponding figures up?

For example:

If C2, C6, C7, C12 was "A" and L2 was £2, L6 was £3.50, L7 was £2.88 and L12 was £4.12

Then if C3 and C4 was "B" and L3 was £5 and L4 was £3

I hope that explains what I'm after. Basically I want to add up all the A's, B's and C's.

2. ## Re: Excel Formula Needed, Please

Welcome to the forum.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I will do it for you this time.)

3. ## Re: Adding One Column Based on Criteria in Another

Use a pivot table. Or place a sample file.

4. ## Re: Adding One Column Based on Criteria in Another

There are instructions at the top of the page explaining how to attach your sample workbook.

5. ## Re: Adding One Column Based on Criteria in Another

Apologies Ali. I'm quite new to this forum and Excel, and thanks for changing the title.

6. ## Re: Adding One Column Based on Criteria in Another

Please provide a sample workbook as requested.

7. ## Re: Adding One Column Based on Criteria in Another

Spreadsheet attached (I think) I hope this is enough info.

8. ## Re: Adding One Column Based on Criteria in Another

See file with 2 options

9. ## Re: Adding One Column Based on Criteria in Another

Thank you very much Vraag, I'll have a little play with it and see how I get on.

10. ## Re: Adding One Column Based on Criteria in Another

Sorry to be a pain, but I've never done anything with a Pivot Table. I can see the answer (ie totals of A, B and C) but I have no idea how they got there.
I've tried C&P the table into my actual spreadsheet, but I'm still lost.

11. ## Re: Adding One Column Based on Criteria in Another

It is quite basic in Excel. So you just have to find out how it works on the www.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1