# Needed: Calculation formule with different columns

1. ## Needed: Calculation formule with different columns

Dear everyone,

First of all thanks alot for helping!
I have already alot of data in my excel form, now i am creating a new colom in which I want to calculate some data from other colums.

Let me draw a small sketchs as example:
A B C
1 1 848 (All data which belong to the category A=1 (all numbers from B who belong to an 1 @ A)
2 1 343
3 1 234
4 2 232
5 2 45
6 2 567
7 2 565
8 3 920
9 3 842
10 3 34

My question is, what is the formula for C in order to save me alot of time in doing it by hand?
Sorry for my bad explenation, and my even worse english. I hope some1 can help me, thanks alot!!

Kind regards, Elmer

2. ## Re: Pretty basic calculation formula but i forgot it :P

Hi elmerf,

Welcome to the forum.

Is there any logic / equation for C column results basis A & B ?

Regards,
DILIPandey
<click on below * if this helps>

3. ## Re: Pretty basic calculation formula but i forgot it :P

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

4. ## Re: Pretty basic calculation formula but i forgot it :P

Hey, thank you!

Well it is all about orders.

Column A: What day did the order came in?
Column B: What is the amount of this specific order?

Now I am trying to set up column c:
Column C: What is the total amount of orders per day

5. ## Re: Needed: Calculation formule with different columns

Originally Posted by Elmerf
Dear everyone,

First of all thanks alot for helping!
I have already alot of data in my excel form, now i am creating a new colom in which I want to calculate some data from other colums.

Let me draw a small sketchs as example:
A B C
1 1 848 (All data which belong to the category A=1 (all numbers from B who belong to an 1 @ A)
2 1 343
3 1 234
4 2 232
5 2 45
6 2 567
7 2 565
8 3 920
9 3 842
10 3 34

My question is, what is the formula for C in order to save me alot of time in doing it by hand?
Sorry for my bad explenation, and my even worse english. I hope some1 can help me, thanks alot!!

Kind regards, Elmer
Hi Elmer,

Could you please attach a sample file and your requirment in an excel file so that I can have a look at it before I could suggest something?

Regards,
Kiran

6. ## Re: Needed: Calculation formule with different columns

excel opzetje.xlsx

Hope this works, ask me if you need to know anything! Thanks for looking at it!

7. ## Re: Needed: Calculation formule with different columns

I need something like:

=Amount(B;1) or something as a start.
Then next to thati need something like
=SUM;E(B;\$1)

Something like that but i forgot the exact one:p

8. ## Re: Needed: Calculation formule with different columns

not sure.. can you manually put in few results and will try to obtain the same using formula . thanks.

Regards,
DILIPandey
<click on below * if this helps>

9. ## Re: Needed: Calculation formule with different columns

see if this what you were looking for....
let me know if this helps...

10. ## Re: Needed: Calculation formule with different columns

Yes! That is the correct answer indeed! How did you do that, I do understand your code but how do I fill it in for all?

11. ## Re: Needed: Calculation formule with different columns

a better idea would be to do a pivot to see the sum of order amounts for each of the order dates.
I have shown it on "Sum of order amounts" tab on the attachment

12. ## Re: Needed: Calculation formule with different columns

In I7 perhaps
``Please Login or Register  to view this content.``
then double click the handle at the lower right corner of the cell A pivot table will also be possible

13. ## Re: Needed: Calculation formule with different columns

Wow nice, thanks alot! That is the info I needed most
Thank alot man.

14. ## Re: Needed: Calculation formule with different columns

Thanks Elmerf...
click on the star mark if my solution helps you...

15. ## Re: Needed: Calculation formule with different columns

I did Kiran, thanks alot Bye bye all the work is done now haha, have a nice weekend!

#### Thread Information

##### Users Browsing this Thread

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