+ Reply to Thread
Results 1 to 1 of 1

Sumif / pivot

  1. #1
    Forum Contributor
    Join Date
    09-20-2018
    Location
    Jakarta
    MS-Off Ver
    google
    Posts
    125

    Question Sumif / pivot

    Hello everyone,


    I need help to add the total loss and profit on two tables within the same format, for the row 'total profit' with the condition of on two rows below it there's a word 'done'.

    Ex :
    To sum up E10 and E23
    Condition is E12 and E25


    I also have provided the expected result in N2 here in this document :

    https://docs.google.com/spreadsheets...it?gid=0#gid=0

    Thank you
    Last edited by maniacs205; 07-22-2024 at 10:45 AM.

+ 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] Pivot table with SUMIF values
    By benjhardie in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 07-21-2020, 03:34 PM
  2. sumif in power pivot
    By pccamara in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-13-2018, 12:02 PM
  3. SUMPRODUCT...SUMIF...Pivot Table????
    By Tom K in forum Excel General
    Replies: 5
    Last Post: 08-19-2013, 06:50 PM
  4. [SOLVED] Dynamic Sumif with pivot table
    By James_SF in forum Excel General
    Replies: 5
    Last Post: 05-09-2012, 01:22 PM
  5. Pivot table and Sumif excel 10
    By James_SF in forum Excel General
    Replies: 1
    Last Post: 05-05-2012, 05:39 PM
  6. Pivot Table- Sumif
    By aromaveda in forum Excel General
    Replies: 9
    Last Post: 09-14-2009, 04:51 PM
  7. SumIF in Pivot calculated Field
    By rar76 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2007, 06:42 AM

Tags for this Thread

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