Results 1 to 29 of 29

IF statement clause and SUMIF statement formula help!!!!

Threaded View

djmatok IF statement clause and SUMIF... 10-27-2015, 05:18 PM
Sam Capricci Re: IF statement clause and... 10-27-2015, 05:40 PM
djmatok Re: IF statement clause and... 10-28-2015, 09:55 AM
djmatok Re: IF statement clause and... 10-27-2015, 05:43 PM
oeldere Re: IF statement clause and... 10-27-2015, 05:47 PM
djmatok Re: IF statement clause and... 10-27-2015, 05:54 PM
Sam Capricci Re: IF statement clause and... 10-27-2015, 05:58 PM
djmatok Re: IF statement clause and... 10-27-2015, 06:00 PM
CARACALLA Re: IF statement clause and... 10-27-2015, 06:08 PM
djmatok Re: IF statement clause and... 10-27-2015, 06:17 PM
oeldere Re: IF statement clause and... 10-27-2015, 06:09 PM
djmatok Re: IF statement clause and... 10-27-2015, 06:20 PM
djmatok Re: IF statement clause and... 10-27-2015, 06:24 PM
djmatok Re: IF statement clause and... 10-27-2015, 06:15 PM
oeldere Re: IF statement clause and... 10-27-2015, 06:17 PM
djmatok Re: IF statement clause and... 10-27-2015, 06:21 PM
oeldere Re: IF statement clause and... 10-27-2015, 06:53 PM
djmatok Re: IF statement clause and... 10-28-2015, 09:40 AM
oeldere Re: IF statement clause and... 10-28-2015, 10:05 AM
djmatok Re: IF statement clause and... 10-28-2015, 10:07 AM
djmatok Re: IF statement clause and... 10-28-2015, 10:10 AM
oeldere Re: IF statement clause and... 10-28-2015, 10:14 AM
djmatok Re: IF statement clause and... 10-28-2015, 10:24 AM
oeldere Re: IF statement clause and... 10-28-2015, 10:41 AM
djmatok Re: IF statement clause and... 10-28-2015, 10:48 AM
djmatok Re: IF statement clause and... 10-28-2015, 02:53 PM
oeldere Re: IF statement clause and... 10-28-2015, 11:00 AM
oeldere Re: IF statement clause and... 10-28-2015, 03:38 PM
djmatok Re: IF statement clause and... 10-28-2015, 04:48 PM
  1. #1
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    IF statement clause and SUMIF statement formula help!!!!

    I have a set of earnings data with Main payee accounts that have sub accounts, now I am trying to pull earnings either by payee account or subaccount depending on the clients that I'm searching. Please take a look at my attachment. I'm already using the following formula but I want to be able to calculate when I have to pick up the earnings by payee account but minus out the client under that payee account that I have already picked up. =IF(A15=B15,SUMIF($A$2:$A$8,A15,$C$2:$C$8),IF(A15<>B15,SUMIF($B$2:$B$8,B15,$C$2:$C$8)))

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula - sumif statement?
    By Rachel88 in forum Excel General
    Replies: 5
    Last Post: 04-02-2015, 08:25 PM
  2. [SOLVED] How do I pass a MID( statement through a IsNumber in an If, Then, Else clause?
    By needsome in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 04:51 PM
  3. [SOLVED] SQL Transform Statement in VBA - Using Variable in the FROM clause
    By jdorbish in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-06-2012, 09:26 AM
  4. [SOLVED] Formula for Income Statement in financial statement
    By Zunit in forum Excel General
    Replies: 6
    Last Post: 07-02-2012, 02:21 PM
  5. Nested SUMIF statement or multiple SUMIF's
    By Dan27 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2009, 06:55 AM
  6. help with =sumif statement
    By Mile029 in forum Excel General
    Replies: 4
    Last Post: 08-07-2007, 06:00 PM
  7. Help please, IF statement/SUMIF statement
    By Brad_A in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 01-11-2005, 11:06 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