Results 1 to 3 of 3

Help with Formula

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2024
    Location
    Poland
    MS-Off Ver
    Office 365
    Posts
    1

    Post Help with Formula

    HI!

    I have a problem with creating a formula for 2 tables in one file in excel.

    I have a task to do where there will be a calculation, adding up the numbers in Column F3 to F28 for a specific person located in Column A3 to A28, based on whether the number in Columns C32 to C109 has a status in Columns F32 to F109 called “Sukces”, if it has a different status then it is not to include the number in the total for the specific person.

    I tried 2 formulas:
    =SUMIFS(Table2!C32:C109, Table2!A3:A28, A2, Table2!F32:F109, “Success”)
    and
    =SUMPRODUCT((Table2!A3:A28 = A2) * (Table2!F32:F109 = “Success”) * (Table2!C32:C109))
    but they don't work

    below i give a screenshot of the tables, and the table file

    PLEASE HELP
    Zrzut ekranu 2024-12-16 220607.png
    table.xls
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  2. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  3. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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