Excel SUMIFS and VLookup for multiple columns and two sheets

Status: Closed
Prize: $30
Entries Received: 7
Winner: hopkovictoria

Winner

Contest Brief

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

Recommended Skills

Excel

Winner

Post a Contest Like This

Employer Feedback

“Excellent Excel Skills”

jasonsetzer81, United States.

Top entries from this contest

hopkovictoria Ukraine

0
kavinishan Sri Lanka

0
hopkovictoria Ukraine

0
ovaissss Pakistan

0
gellieann3 Philippines

0
ovaissss Pakistan

0
gellieann3 Philippines

0

View More Entries

Public Clarification Board

ovaissss
- 5 years ago
i have done your work correctly, if not i can provide you if give a bit guidance
- 5 years ago
ovaissss
- 5 years ago
dear, please check my files a
- 5 years ago
gellieann3
- 5 years ago
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.
- 5 years ago
ovaissss
- 5 years ago
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.
- 5 years ago