+ Reply to Thread
Results 1 to 10 of 10

Using the same formula.

  1. #1
    Registered User
    Join Date
    04-24-2020
    Location
    Malaysia
    MS-Off Ver
    3
    Posts
    9

    Using the same formula.

    I'm just start learning and i have some problem with the formula.
    how to put the right formula total amount by following the date.
    =SUMPRODUCT(ISNUMBER(SEARCH($C$2:$C$11,J2))*($D$2:$D$11))

  2. #2
    Registered User
    Join Date
    04-24-2020
    Location
    Malaysia
    MS-Off Ver
    3
    Posts
    9

    Re: Using the same formula.

    Attachment 677344
    here is some sample

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,909

    Re: Using the same formula.

    Selecting Attachment 677344 in post #2 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator"
    Please utilize the instructions in the banner at the top of the page to upload a sample .xls or .xlsx file
    By the way, if MS-Off Ver: 3 in your profile means that you are using the 2003 version of Excel then please put 2003, or whatever version you are using, in your profile.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #4
    Registered User
    Join Date
    04-24-2020
    Location
    Malaysia
    MS-Off Ver
    3
    Posts
    9

    Re: Using the same formula.

    sorry , im new to this. may i know how to use this formula but for same date?
    =SUMPRODUCT(ISNUMBER(SEARCH("denney wage",Statement!B2:B16000))*(Statement!A2:A16000>="05/04/09"+0)*(Statement!A2:A16000<="30/04/09"+0),Statement!C2:C16000)

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,909

    Re: Using the same formula.

    If by "same date" you mean a single date such as April 5th, 2009, then the formula could read:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If that isn't what you mean then please explain or, better yet, upload a file that illustrates what you want.
    Let us know if you have any questions.

  6. #6
    Registered User
    Join Date
    04-24-2020
    Location
    Malaysia
    MS-Off Ver
    3
    Posts
    9

    Re: Using the same formula.

    IN THE COLUMN B : DATE
    IN THE COLUMN C : ID TEXT + NUMBER ( Example : my02570348578 )
    IN THE COLUMN D : AMOUNT

    IN THE COLUMN J : MULTIPLE ID
    IN THE COLUMN K : TOTAL AMOUNT

    im using this formula right now , it work fine but i dont know how to calculate it by the same date .
    =SUMPRODUCT(ISNUMBER(SEARCH($C$2:$C$11,J2))*($D$2:$D$11))

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,909

    Re: Using the same formula.

    Here is a guess:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    It is about the best that I can do without being able to see what you want. I am still confused as to what "same date" means, and am in hopes that when/if I can see a sample file, I'll be able to understand.
    Let us know if you have any questions.

  8. #8
    Registered User
    Join Date
    04-24-2020
    Location
    Malaysia
    MS-Off Ver
    3
    Posts
    9

    Re: Using the same formula.

    i just found out how to turn into xlsx file . this is the exampleAttachment 678034

  9. #9
    Registered User
    Join Date
    04-24-2020
    Location
    Malaysia
    MS-Off Ver
    3
    Posts
    9

    Re: Using the same formula.

    thank you very much , is the right formula !

  10. #10
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,909

    Re: Using the same formula.

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. 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