+ Reply to Thread
Results 1 to 3 of 3

Possible IF function

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Spokane, WA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Possible IF function

    Okay I have an expense report where the employees choose method pf payment the options are personal card or business card I need the spread sheet to keep separate totals for each, but at the same time show same the total of the whole column.
    attached is the current expense report help if you can

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,102

    Re: Possible IF function

    where do you want to put the totals for PC and BC

    you can use a
    SUMIF(P:P, "Personal Card", Q:Q)
    SUMIF(P:P, "Company Card", Q:Q)
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    05-21-2013
    Location
    UK
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    86

    Re: Possible IF function

    The sheet is password protected so not sure exactly where you want this. However, I guess you could add a couple cells above the grand total for the payment type sub totals and add them with something like:
    Please Login or Register  to view this content.
    If I've helped or inspired, please click the star.

+ 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