+ Reply to Thread
Results 1 to 4 of 4

Summing columns to matched symbol/letter for expense form

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Derby, England
    MS-Off Ver
    2010, 2013 2016 Pro
    Posts
    85

    Summing columns to matched symbol/letter for expense form

    This is a manual expence form that i need to automate.

    I'm relatively new to excel and cant seem to grasp the format used when doing multiple criteria, i also want to keep the form as neat as possible and don't want 00.00 in the formula box if there is no value, although i could use conditional formatting, if needed, any help and advice gratefully received.

    In columns E and F shows cash receipted
    In columns G and H shows cash no receipt
    In columns I and J shows credit card purchases

    I need to calculate each section relavent to the curency being used at the time (we travel all over the world so i need to match what is in C29 to C33 rather than give actual symbols)

    So all £, $, €, K, B would need to be calculated individually and put in there relavent row in K29 to K33, then the diference between Used K29 to K33 and Available would be in, Remaining L29 to L33.

    The main thing is i need whatever symbol/letter i put in C29 to C33 to be variable due to contries traveled

    Expence Form.xlsx
    Last edited by RoyLittle0; 01-07-2012 at 10:12 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Summing columns to matched symbol/letter for expense form

    One way of summing the values for each currency symbol:

    K29: =SUMIF($F$5:$F$25,$C29,$E$5:$E$25)+SUMIF($H$5:$H$25,$C29,$G$5:$G$25)+SUMIF($J$5:$J$25,$C29,$I$5:$I$25)


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-04-2012
    Location
    Derby, England
    MS-Off Ver
    2010, 2013 2016 Pro
    Posts
    85

    Re: Summing columns to matched symbol/letter for expense form

    TMShucks

    Thanks for that, works perfect, I understand now how it works, I'll spend some time tonight trying to write it for myself from scratch.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Summing columns to matched symbol/letter for expense form

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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