In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s)...
70.2K
Verified Solution
Link Copied!
Question
Accounting
In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as specified and without creating a helper column, using Filters, or Pivot Tables.
Date
Product
Region
SalesRep
Customer
Sales
COGS
Gross Profit
4/19/2020
Product3
Region3
SalesRep2
Customer16
$ 14,046
$ 5,337
All products:
4/19/2020
Product7
Region4
SalesRep15
Customer72
$ 2,504
$ 1,703
Product9 only:
4/19/2020
Product2
Region4
SalesRep18
Customer71
$ 1,505
$ 843
Product3 and SalesRep16 only:
4/19/2020
Product6
Region4
SalesRep14
Customer88
$ 4,232
$ 2,793
4/19/2020
Product3
Region4
SalesRep3
Customer65
$ 5,947
$ 3,390
4/19/2020
Product1
Region8
SalesRep6
Customer100
$ 5,721
$ 3,204
4/19/2020
Product10
Region8
SalesRep16
Customer68
$ 14,744
$ 5,308
4/19/2020
Product7
Region2
SalesRep1
Customer85
$ 4,018
$ 2,371
4/19/2020
Product10
Region5
SalesRep6
Customer6
$ 6,442
$ 4,445
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
