+ Reply to Thread
Results 1 to 2 of 2

Sumifs Function

Hybrid View

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    15

    Question Sumifs Function

    Hey Im not sure if im using the right function or if im using it right. I have a spreadsheet with fours sheets. I need to calculate the commision for each person on the marketing staff sheet at 15% for each campaign they are associated with on the campagin sheet and them take the 15% from the campaign charges sheet and add them all together.

    Im totally lost and wondering if you could help. I think imn using the right function but could be totally lost.

    Thanks.

    attached is the sheet im using
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Sumifs Function

    Hi

    I have no doubt some-one will offer a simpler suggestion for this, but intil then, try this

    1. add a helper column on Campaign (I used I) and copy this down...
    =VLOOKUP(G3,'Campaign Charges'!$B$2:$C$7,2,0)*0.15
    Then on Staff, use this, copied down...
    =SUMIF(Campaign!$F$4:$F$26,'Marketing Staff'!B3,Campaign!$I$3:$I$26)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Loop function SUMIFS
    By jnh0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-05-2013, 12:35 PM
  2. [SOLVED] NEED HELP! SUMIFS function
    By thedefense in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2012, 08:47 PM
  3. [SOLVED] SUMIFS function?
    By jed38 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2012, 04:33 PM
  4. OR function in SUMIFS
    By skysurfer in forum Excel General
    Replies: 6
    Last Post: 05-09-2012, 02:41 AM
  5. Need help with SUMIFS function please
    By mTriniDee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2008, 11:50 AM

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