+ Reply to Thread
Results 1 to 10 of 10

Sum the figures of a table to different cells based on its criteria..

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Question Sum the figures of a table to different cells based on its criteria..

    Hi,

    I want the total of my table to be placed on two different cells based on its value.
    If its a cash transaction i want the total to be placed on Total cash cell and vise versa.

    Some one please write a formula to solve this.

    Thanks in advance.

    Anees.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sum the figures of a table to different cells based on its criteria..

    Show the desired output filled manually.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Sum the figures of a table to different cells based on its criteria..

    please find the attachement, where i entered those figures manually.
    Attached Files Attached Files

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sum the figures of a table to different cells based on its criteria..

    Try this....
    In M5
    Please Login or Register  to view this content.
    and copy down.

    In N5
    Please Login or Register  to view this content.
    and copy down.

  5. #5
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Sum the figures of a table to different cells based on its criteria..

    Thanks, that really helped me.

    Now what if i want it be a running balance, as you can see on the attachment.
    Attached Files Attached Files

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sum the figures of a table to different cells based on its criteria..

    In M5
    Please Login or Register  to view this content.
    In N5
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Sum the figures of a table to different cells based on its criteria..

    Thank you very much for the help.

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sum the figures of a table to different cells based on its criteria..

    You're welcome.
    If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

  9. #9
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Sum the figures of a table to different cells based on its criteria..

    One last question.
    What if i want add another criteria "cheque" and If a transaction was made either by card or cheque, i want it to be in Bank total column.
    Please find the attachement.
    Attached Files Attached Files

  10. #10
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Sum the figures of a table to different cells based on its criteria..

    welcome to the forum, Hussain. maybe:
    =IF(OR(J5={"card","cheque"}),E5-I5+N4,N4)
    or:
    =N4+IF(OR(J5={"card","cheque"}),E5-I5)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional formatting based on the difference value between figures in two cells
    By Karczoch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2014, 07:50 AM
  2. [SOLVED] VBA fill in cells in a new column in table based on multiple criteria from other columns
    By HRA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2013, 06:48 AM
  3. Conversion of an array of figures inputted into cells as word figures to Excel figures
    By Allan Simpson730 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2013, 07:25 AM
  4. [SOLVED] Applying figures and sums of figures to relevent cells
    By JakeMann in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2012, 10:08 AM
  5. Add figures based on 3 criteria from Test Data Sheet
    By tek9step in forum Excel General
    Replies: 13
    Last Post: 03-02-2011, 04:13 PM

Bookmarks

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