Query uploaded again with .xls
Posts by vikmeh
-
-
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