which function would i use for this and how is it used? thankyou ...

80.2K

Verified Solution

Question

Accounting

which function would i use for this and how is it used? thankyou
image
3.1.1 Perform logical operations by using nested functions including the IF0, IFSO, SWTCHO, SUMIFO, AVERAGEIFO, COUNTIF0, SUMIFSO, AVERAGEIFSO, COUNTIFSO, MAXIFSO, MINIFSO, AND0, ORO,NOTO, and LETO functions On the Sales Report worksheet, add a function in C7:C19 that retums the number of sales in the Sales worksheet for the products listed in B7:B19. 2.2.4 Calculate data by inserting subtotals and totals On the Sales Report worksheet, use Subtotals to create Totals and Averages for the I. values in the Number of Sales column

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!
Become a Member

Other questions asked by students