# Using the same formula.

1. ## 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. ## Re: Using the same formula.

Attachment 677344
here is some sample

3. ## 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.

4. ## 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. ## 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:
`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. ## 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. ## Re: Using the same formula.

Here is a guess:
Formula:
`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. ## Re: Using the same formula.

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

9. ## Re: Using the same formula.

thank you very much , is the right formula !

10. ## 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.

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