#### VikMeh

##### New Member

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?

#### Attachments

• 20 KB Views: 5

#### vletm

##### Excel Ninja
VikMeh
Seems that You didn't get an idea?
... hmm? ... seems that You got something else.

#### Attachments

• 8.5 KB Views: 8

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

• 26.5 KB Views: 1

#### 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)