• 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
 

vletm

Excel Ninja
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?
 

vletm

Excel Ninja
VikMeh
As a new member, You should reread Forum Rules:
 

navic

Active Member
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?
 

Ateeb Ali

Member
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

vletm

Excel Ninja
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)
 
Top