Excel SUMIFS and VLookup for multiple columns and two sheets

  • Stanje: Closed
  • Nagrade: $30
  • Prejetih vnosov: 7
  • Zmagovalec/ka: hopkovictoria

Navodila natečaja

Hello - I have a simple contest for Excel Masters for a spreadsheet:

Period Flow thru Worksheet:

Criteria 1: Column I “Actual”: Match (sumifs) column C with “Sales Tab” column b “restaurant_id”
Criteria 2: sales tab “business date” (column C) with calendar tab “date” (column A)
Criteria 3: Period Flow Thru Worksheet row 3 Period, Week, Year with Calendar Tab columns AK (ReportingWeekPeriodYearString)

That value goes into Week three tab column E. Match column B with with “Sales Tab” column b “restaurant_id”



The value in Period Flow thru Worksheet column U goes into week three column G matching Week 3 tab column B with Period Flow thru Worksheet column S

Priporočene spretnosti

Delodajalčev feedback

“Excellent Excel Skills”

Profilna slika jasonsetzer81, United States.

Najboljši vnosi tega natečaja

Poglej več vnosov

Javna tabla za pojasnila

  • ovaissss
    ovaissss
    • pred 5 let

    i have done your work correctly, if not i can provide you if give a bit guidance

    • pred 5 let
  • ovaissss
    ovaissss
    • pred 5 let

    dear, please check my files a

    • pred 5 let
  • gellieann3
    gellieann3
    • pred 5 let

    I have done the first three criteria. I just don't get the next parts.

    "That value goes into Week three tab column E. Match column B with with “Sales Tab” column b “restaurant_id”
    Which value are you referring to?


    "The value in Period Flow thru Worksheet column U goes into week three column G matching Week 3 tab column B with Period Flow thru Worksheet column S"

    It throws an error on "Flow Thru", Period Flow thru column S.

    Please explain more.

    • pred 5 let
  • ovaissss
    ovaissss
    • pred 5 let

    i can provide you complete working just make it clear, feel free to message, i need some assistance regarding this as i can do this for you.

    • pred 5 let

Kako začeti z natečaji

  • Objavi ta natečaj

    Objavi svoj natečaj Hitro in preprosto

  • Prejmi na tone vnosov

    Prejmi na tisoče vnosov S celega sveta

  • Dodeli natečaj najboljšemu vnosu

    Dodeli natečaj najboljšemu vnosu Prenesi datoteke - Preprosto!

Objavi natečaj zdaj ali pa pridruži se nam še danes!