• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please help to create a formula

VikMeh

New Member
67501

Will appreciate if someone can help me create 2 formulas for this:

Formula No.1 Reqd =Total Sales of Eagle Toy Divided by No. of days till today starting 04-04-2020
Formula No.1 Reqd =Total Sales of Eagle Toy + Total Sales of Vulture Toy Divided by No. of days till today starting 04-04-2020

I'm so naive to create an effective formula & therefore I did the following but of course its not working. Please sugggest:

Formula 1=SUMIF(A3:A12; "*eagle*"; F3:F12)/TODAY()-B3
Formula 2=SUMIF(A3:A12; "*eagle*"; F3:F12)+SUMIF(A3:A12; "*vulture*"; F3:F12)/TODAY()-B3
 
VikMeh
Your Formula 1 ... works with cell E3 after You check Your Divided by part
-- now, it's 'eagles' / Today() - B3

it calculates 'eagles' / today = ET and after that
ET - B3 .... and that is something else You would like to do.
Did You get an idea ... what?
 
VikMeh
Seems that You didn't get an idea?
... hmm? ... seems that You got something else.
 

Attachments

  • VikMeh.xlsb
    8.5 KB · Views: 8
VikMeh
As a new member, You should reread Forum Rules:
 
Will appreciate if someone can help me create 2 formulas for this:
Sorry but I don't fully understand you.
You wrote the result in 'K4' cell value 3500? Is this the correct result? Shouldn't the result be 3640?
Please write the expected results in 'K2', 'K3', 'K4' and 'K5' cells.
What is the logic of your calculations?
 
Both your formulas working fine;
Formula 1=SUMIF(A3:A12; "*eagle*"; F3:F12)/TODAY()-B3
Formula 2=SUMIF(A3:A12; "*eagle*"; F3:F12)+SUMIF(A3:A12; "*vulture*"; F3:F12)/TODAY()-B3
 

Attachments

  • Excel Qn.xls
    26.5 KB · Views: 1
Ateeb Ali
You wrote that those formulas working fine - Yes!
BUT
do those give expected results?
eg if A = 6, B = 3 & C = 2
Formula = A / B - C = 6/3 - 2 = 0
expected = A / (B-C) = 6 / (3-2) = 6 (no. of days)
 
Back
Top