Please help me create a formula

vikmeh · Apr 30th 2020

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.2 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

Pecoflyer · Apr 30th 2020

perhaps post a sample sheet with some data and expected results? Pictures are nice to look at but useless

vikmeh · Apr 30th 2020

Query uploaded again with .xls

**royUK** · Apr 30th 2020

Welcome to ozgrid Forum. Your post has been reported for cross-posting. Please read our Forum Rules to understand why this has happened and what to do in future.

Cross-post:

https://chandoo.org/forum/thre…o-create-a-formula.44187/

Please help me create a formula

Participate now!

Share