Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


Photo

SUM function with complications. Need help with formula.

- - - - - sum formulas excel addition adding

  • Please log in to reply
3 replies to this topic

#1
kbdavis

kbdavis

    Newbie

  • Member
  • 10 posts
  • OS:Windows 7 x64
  • Country: Country Flag

Let's see if anyone out there could help me out with this problem...

 
Let's say I was needing to sum up the total in column B.. Easy enough, huh? Well, if it were only that simple (which I am sure it is for most of the people reading this or I wouldn't be here).
 
Let's say the only cells in column B i wanted to add up were cells that contained a specific "Client Code" in column A.
 
Example:

|    A    |    B    |
| ABC100  | $500.00 |
| ZZZ900  | $100.00 |
| ABC100  | $200.00 |
| XYZ350  | $ 50.00 |

I am needing it to automatically add up all the #s in "B" that has the client code of ABC100. So that would be B1,B3, and to ignore the rest. Is there a formula that would allow me to do this?

 

 

Thanks in advance!


Edited by kbdavis, 05 August 2013 - 11:12 PM.



How to remove advertisement from MSFN

#2
allen2

allen2

    Not really Newbie

  • Member
  • PipPipPipPipPipPipPip
  • 1,812 posts

To do it you'll need a macro most likely:

- first you need to get unique value of col A

- for each unique value, find all line (j) of col A containing it and add the cell (j,B )

Another way is using the subtotal feature after sorting on Col A.


Edited by allen2, 05 August 2013 - 11:27 PM.


#3
Yzöwl

Yzöwl

    Wise Owl

  • Super Moderator
  • 4,532 posts
  • OS:Windows 7 x64
  • Country: Country Flag

Donator

It's a long time since I used excel, but it sounds to me as if you need to use the SUMIF function.

 

Try this, based on your example and assuming ROW1 begins ABC100 and the currency symbols are added only as part of the cell format:

=SUMIF(A1:A4,"ABC100",B1:B4)

Attached File  example.png   7.18KB   1 downloads



#4
kbdavis

kbdavis

    Newbie

  • Member
  • 10 posts
  • OS:Windows 7 x64
  • Country: Country Flag

It's a long time since I used excel, but it sounds to me as if you need to use the SUMIF function.

 

Try this, based on your example and assuming ROW1 begins ABC100 and the currency symbols are added only as part of the cell format:

=SUMIF(A1:A4,"ABC100",B1:B4)

attachicon.gifexample.png

That worked Perfectly!

 

Thank you very much.

 

I did make a very slight modification to the formula mentioned, using =SUMIF(A:A,"ABC100",B: B)

 

That helped out a lot!


Edited by Tripredacus, 07 August 2013 - 07:43 AM.
disabled emoticons






Also tagged with one or more of these keywords: sum, formulas, excel, addition, adding

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users



How to remove advertisement from MSFN