38|EXCEL – Cowabunga Surf Audit

[Mason_Ewing]

Challenge38_Cowabunga_Inventory.xlsx (17.0 KB)

[Erika_Campbell]

[isabellaluedtke]

This challenge was great to help me brush up on the SUMIF Function. I discovered that Cowabunga did not count Inventory #42-0047-1457, The Sundrift, which was the main reason why inventory was understated and sales were overstated.

The SUMIF Function I used to determine if inventory was overcounted was the following:

=IF(D2=C2,0,IF(D2<C2,0,D2-C2))

The SUMIF Function I used to determine if inventory was undercounted was the following:

=IF(D2=C2,0,IF(D2>C2,0,C2-D2))

In the end, inventory was overcounted by 14 and undercounted by 17, leading inventory to be understated by 3 overall.

Here is the adjusting entry I made to correct the accounts:

0203_Luedtke_38ExcelChallenge.xlsx (25.3 KB)

[Matt_Bailey]

Challenge38_Cowabunga_Inventory.xlsx (18.1 KB)
This challenge helped me remember how to use the xlookup function, and learning how to use the subtotal feature was helpful too!

[Blake_Moser]

[Kyle_Parkinson]

This challenge was a great refresher on using the IF function, including a nested IF. I used an xlookup to compare the audit and cowabunga count, then used if statements to determine over or understatement of inventory.

[Abigail_Smith]

This was a great challenge to learn/refresh xlookup and the subtotal function. Thank you! Here is my solution. Challenge38_Cowabunga_Inventory (Abigail Smith).xlsx (19.5 KB)

[Elise_Snow]

Challenge38_Cowabunga_Inventory.xlsx (17.5 KB)
I haven’t quite learned some of these techniques so I’m sure I did it the long way. Great problem.

[Samuel_Allen]

I used vlookup instead of the xlookup shown in the solution, just more used to that one

[Nathan_Farrell]

The walkthrough video was super helpful to refresh my excel basics

[Rachel_Cluff]

This was a fun activity! Thanks Alex! Cowabungaaa

[Jill_Davis]

0403_Davis_Cowabunga_Inventory.xlsx (17.4 KB)
My journal entry. Submission for Professor Summer’s class.

[Aaron_Gill]

I used a slightly simplified version of the over/understatement, but still got the same journal entry!

[Patrick_Hayden]

I also got a higher amount then everyone else it seems.

[Tessa_Croft]

Challenge38_Cowabunga_Inventory.xlsx (16.3 KB)

[Zach_Dullum]

This was a fun one! After sorting and filtering the inventory, I utilized XLOOKUP and nested if functions to arrive at a solution for this practice problem.

[Mitchell_Payne]

[Garrett_Elkins]

[alexpeek]

Took me MUCH longer than I would have liked. I definitely need to put in a little more work this semester!

[Allison_Richardson]

I used a pivot table and vlookup to compare the two. Here are my journal entries: