Jewells0905
New Member
- Joined
- Mar 10, 2024
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
- MacOS
The stated goal of the company is as follows:
Then I am trying to find the percentage change for each month comparing 2022 to 2023 in cells B14:G21. I have ensured this table has values formatted as percentages, and reduced the number of decimal places to 0.
Finally I have stated in cell I14 if the goal was met. Type either "Yes" or "No".
The formula's I'm using are listed below.
Sheet 2022 and 2023 in Column F to find the profit - =($D2 - $C2) * $E2. Column C is cost_to_make, column D is Price_sold, column E is quantity. This is the same for Sheet 2023.
On the Analysis Sheet, I am using this formula in cell B3 to find the Profit increases for Jan 2022 - =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"AL"). I have changed the year and state abbreviation for each as well. I am not able to link the sheet so I will include some copy and pastes below.
Analysis Sheet A1:M21 -
here it is with the formulas all visible
sheet 2022 - this is just the first 10 rows this sheet contains 491 rows total -
here is sheet 2022 without the formula visible
sheet 2023 - this is just the first 10 rows this sheet contains 515 rows total -
here it is with the formula in column f visible -
The issue I'm having is that my formulas in the profit table on the Analysis sheet are all producing $0.00 there fore giving me a #DIVO error in my lower table as well.
I am currently working on this in google sheets.
Any help is greatly appreciated. thank you!
- Increase profits in at least 4 of the months in January through June in 2023 by 15% when compared to the same month in the previous year for each state, and
- Have zero instances of a decrease in profit in any month from January to June when compared to the same month in the previous year for each state.
Then I am trying to find the percentage change for each month comparing 2022 to 2023 in cells B14:G21. I have ensured this table has values formatted as percentages, and reduced the number of decimal places to 0.
Finally I have stated in cell I14 if the goal was met. Type either "Yes" or "No".
The formula's I'm using are listed below.
Sheet 2022 and 2023 in Column F to find the profit - =($D2 - $C2) * $E2. Column C is cost_to_make, column D is Price_sold, column E is quantity. This is the same for Sheet 2023.
On the Analysis Sheet, I am using this formula in cell B3 to find the Profit increases for Jan 2022 - =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"AL"). I have changed the year and state abbreviation for each as well. I am not able to link the sheet so I will include some copy and pastes below.
Analysis Sheet A1:M21 -
| January | February | March | April | May | June | |||||||
| State | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 |
| AL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| AR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| FL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| GA | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| LA | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| MS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| OK | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| TX | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| States | January | Februrary | March | April | May | June | Was the overall goal met? | |||||
| AL | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | No | |||||
| AR | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| FL | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| GA | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| LA | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| MS | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| OK | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
| TX | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
| January | February | March | April | May | June | |||||||
| State | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 |
| AL | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"AL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"AL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"AL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"AL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=3/1/2022",'2022'!$A:$A,"AL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"AL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"AL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"AL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"AL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"AL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"AL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"AR") |
| AR | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"AR") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"AR") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"AR") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"AR") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2022",'2023'!$A:$A,"AR") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"AR") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"AR") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"AR") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"AR") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"AR") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"AR") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"AL") |
| FL | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"FL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"FL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"FL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"FL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2022",'2023'!$A:$A,"FL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"FL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"FL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"FL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"FL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"FL") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"FL") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"FL") |
| GA | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"GA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"GA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"GA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"GA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2022",'2023'!$A:$A,"GA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"GA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"GA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"GA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"GA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"GA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"GA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"GA") |
| LA | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"LA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"LA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"LA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"LA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2022",'2023'!$A:$A,"LA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"LA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"LA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"LA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"LA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"LA") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"LA") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"LA") |
| MS | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"MS") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"MS") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"MS") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"MS") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2022",'2023'!$A:$A,"OK") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"MS") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"MS") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"MS") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"MS") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"MS") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"MS") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"MS") |
| OK | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"OK") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"OK") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"OK") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"OK") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2022",'2023'!$A:$A,"TX") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"OK") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"OK") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"OK") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"OK") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"OK") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"OK") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"OK") |
| TX | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=1/1/2022",'2022'!$A:$A,"TX") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=1/1/2023",'2023'!$A:$A,"TX") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=2/1/2022",'2022'!$A:$A,"TX") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=2/1/2023",'2023'!$A:$A,"TX") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2022",'2023'!$A:$A,"") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=3/1/2023",'2023'!$A:$A,"TX") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=4/1/2022",'2022'!$A:$A,"TX") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=4/1/2023",'2023'!$A:$A,"TX") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=5/1/2022",'2022'!$A:$A,"TX") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=5/1/2023",'2023'!$A:$A,"TX") | =SUMIFS('2022'!$F:$F,'2022'!$A:$A,">=6/1/2022",'2022'!$A:$A,"TX") | =SUMIFS('2023'!$F:$F,'2023'!$A:$A,">=6/1/2022",'2023'!$A:$A,"TX") |
| States | January | Februrary | March | April | May | June | Was the overall goal met? | |||||
| AL | =(C3-B3)/B3 | =(E3-D3)/E3 | =(G3-F3)/H3 | =(I3-H3)/I3 | =(K3-J3)/K3 | =(M3-L3)/M3 | =IF(COUNTIF(B14:G21,">=0")>=4,"Yes","No") | |||||
| AR | =(C4-B4)/B4 | =(E4-D4)/E4 | =(G4-F4)/H4 | =(I4-H4)/I4 | =(K4-J4)/K4 | =(M4-L4)/M4 | ||||||
| FL | =(C5-B5)/B5 | =(E5-D5)/E5 | =(G5-F5)/H5 | =(I5-H5)/I5 | =(K5-J5)/K5 | =(M5-L5)/M5 | ||||||
| GA | =(C6-B6)/B6 | =(E6-D6)/E6 | =(G6-F6)/H6 | =(I6-H6)/I6 | =(K6-J6)/K6 | =(M6-L6)/M6 | ||||||
| LA | =(C7-B7)/B7 | =(E7-D7)/E7 | =(G7-F7)/H7 | =(I7-H7)/I7 | =(K7-J7)/K7 | =(M7-L7)/M7 | ||||||
| MS | =(C8-B8)/B8 | =(E8-D8)/E8 | =(G8-F8)/H8 | =(I8-H8)/I8 | =(K8-J8)/K8 | =(M8-L8)/M8 | ||||||
| OK | =(C9-B9)/B9 | =(E9-D9)/E9 | =(G9-F9)/H9 | =(I9-H9)/I9 | =(K9-J9)/K9 | =(M9-L9)/M9 | ||||||
| TX | =(C10-B10)/B10 | =(E10-D10)/E10 | =(G10-F10)/G10 | =(I10-H10)/I10 | =(K10-J10)/K10 | =(M10-L10)/M10 |
sheet 2022 - this is just the first 10 rows this sheet contains 491 rows total -
| purchase_date | product | cost_to_make | price_sold | quantity | profit | category | brand | customer | customer_email | state |
| 1/1/2022 | Bread - Olive | 5.46 | 16.1 | 38 | =($D2 - $C2) * $E2 | household | Skimia | Jud Lyosik | jlyosik23@netvibes.com | GA |
| 1/1/2022 | Cape Capensis - Fillet | 55.44 | 55.49 | 78 | =($D3 - $C3) * $E3 | food | Aibox | Devonne Brenard | dbrenardg3@ezinearticles.com | TX |
| 1/3/2022 | Chocolate - Dark Callets | 50.96 | 95.74 | 2 | =($D4 - $C4) * $E4 | personal care | Linkbridge | Dermot Reidie | dreidie45@soundcloud.com | TX |
| 1/3/2022 | Wine - Charddonnay Errazuriz | 13.67 | 82.7 | 11 | =($D5 - $C5) * $E5 | food | Mybuzz | Riki Fulton | rfulton76@goo.gl | FL |
| 1/4/2022 | Coke - Classic, 355 Ml | 0.58 | 18.83 | 74 | =($D6 - $C6) * $E6 | personal care | Skyvu | Lita Hallwood | lhallwood1e@berkeley.edu | MS |
| 1/4/2022 | Vermouth - Sweet, Cinzano | 4.60 | 64.44 | 99 | =($D7 - $C7) * $E7 | personal care | Bubblebox | Royce Tomblings | rtomblingsne@sfgate.com | TX |
| 1/6/2022 | Towel Dispenser | 30.34 | 75.82 | 13 | =($D8 - $C8) * $E8 | food | Camimbo | Bartholemy Verdun | bverdunir@unc.edu | AR |
| 1/6/2022 | Napkin White - Starched | 30.95 | 43.6 | 8 | =($D9 - $C9) * $E9 | household | Twitterwire | Cate Doy | cdoyq1@reuters.com | AL |
| 1/7/2022 | Temperature Recording Station | 0.91 | 2.31 | 7 | =($D10 - $C10) * $E10 | beverages | Realmix | Lazare Felten | lfelten2z@mtv.com | TX |
| purchase_date | product | cost_to_make | price_sold | quantity | profit | category | brand | customer | customer_email | state |
| 1/1/2022 | Bread - Olive | 5.46 | 16.1 | 38 | $404.43 | household | Skimia | Jud Lyosik | jlyosik23@netvibes.com | GA |
| 1/1/2022 | Cape Capensis - Fillet | 55.44 | 55.49 | 78 | $4.07 | food | Aibox | Devonne Brenard | dbrenardg3@ezinearticles.com | TX |
| 1/3/2022 | Chocolate - Dark Callets | 50.96 | 95.74 | 2 | $89.56 | personal care | Linkbridge | Dermot Reidie | dreidie45@soundcloud.com | TX |
| 1/3/2022 | Wine - Charddonnay Errazuriz | 13.67 | 82.7 | 11 | $759.36 | food | Mybuzz | Riki Fulton | rfulton76@goo.gl | FL |
| 1/4/2022 | Coke - Classic, 355 Ml | 0.58 | 18.83 | 74 | $1,350.61 | personal care | Skyvu | Lita Hallwood | lhallwood1e@berkeley.edu | MS |
| 1/4/2022 | Vermouth - Sweet, Cinzano | 4.60 | 64.44 | 99 | $5,923.85 | personal care | Bubblebox | Royce Tomblings | rtomblingsne@sfgate.com | TX |
| 1/6/2022 | Towel Dispenser | 30.34 | 75.82 | 13 | $591.24 | food | Camimbo | Bartholemy Verdun | bverdunir@unc.edu | AR |
| 1/6/2022 | Napkin White - Starched | 30.95 | 43.6 | 8 | $101.22 | household | Twitterwire | Cate Doy | cdoyq1@reuters.com | AL |
| 1/7/2022 | Temperature Recording Station | 0.91 | 2.31 | 7 | $9.83 | beverages | Realmix | Lazare Felten | lfelten2z@mtv.com | TX |
sheet 2023 - this is just the first 10 rows this sheet contains 515 rows total -
| purchase_date | product | cost_to_make | price_sold | quantity | profit | category | brand | customer | customer_email | state |
| 1/1/2023 | Sugar - Palm | 26.88 | 67.72 | 1 | $40.84 | food | Blogtags | Etta Wardingley | ewardingley2u@artisteer.com | TX |
| 1/1/2023 | Coffee - Egg Nog Capuccino | 2.14 | 88.48 | 49 | $4,230.56 | household | Topicblab | Ashla Jeste | ajestee1@simplemachines.org | TX |
| 1/3/2023 | Soup - Campbells Beef Stew | 6.94 | 31.17 | 99 | $2,399.10 | beverages | Thoughtbeat | My Tiley | mtiley7l@admin.ch | TX |
| 1/3/2023 | Tomatoes | 85.53 | 93.74 | 75 | $616.07 | household | Shuffletag | Lucian Sherrott | lsherrottr4@biblegateway.com | TX |
| 1/4/2023 | Bread - Kimel Stick Poly | 44.15 | 90.26 | 86 | $3,965.60 | beverages | Kazu | Dianemarie Di Filippo | ddie@cdbaby.com | TX |
| 1/4/2023 | Coffee Decaf Colombian | 1.79 | 25.06 | 1 | $23.27 | beverages | Voonix | Kameko Grattan | kgrattan6f@arstechnica.com | GA |
| 1/4/2023 | Crab - Dungeness, Whole, live | 42.64 | 95.27 | 59 | $3,105.10 | food | Feedspan | Price Hirschmann | phirschmannmh@cbsnews.com | TX |
| 1/4/2023 | Coffee Decaf Colombian | 19.54 | 37.20 | 50 | $882.86 | household | Blogtags | Ade Hancock | ahancock7i@spiegel.de | TX |
| 1/5/2023 | Sprouts Dikon | 63.64 | 72.64 | 86 | $773.70 | personal care | Flipstorm | Ade Bradneck | abradneckb6@istockphoto.com | AR |
| purchase_date | product | cost_to_make | price_sold | quantity | profit | category | brand | customer | customer_email | state |
| 1/1/2023 | Sugar - Palm | 26.88 | 67.72 | 1 | =($D2 - $C2) * $E2 | food | Blogtags | Etta Wardingley | ewardingley2u@artisteer.com | TX |
| 1/1/2023 | Coffee - Egg Nog Capuccino | 2.14 | 88.48 | 49 | =($D3 - $C3) * $E3 | household | Topicblab | Ashla Jeste | ajestee1@simplemachines.org | TX |
| 1/3/2023 | Soup - Campbells Beef Stew | 6.94 | 31.17 | 99 | =($D4 - $C4) * $E4 | beverages | Thoughtbeat | My Tiley | mtiley7l@admin.ch | TX |
| 1/3/2023 | Tomatoes | 85.53 | 93.74 | 75 | =($D5 - $C5) * $E5 | household | Shuffletag | Lucian Sherrott | lsherrottr4@biblegateway.com | TX |
| 1/4/2023 | Bread - Kimel Stick Poly | 44.15 | 90.26 | 86 | =($D6 - $C6) * $E6 | beverages | Kazu | Dianemarie Di Filippo | ddie@cdbaby.com | TX |
| 1/4/2023 | Coffee Decaf Colombian | 1.79 | 25.06 | 1 | =($D7 - $C7) * $E7 | beverages | Voonix | Kameko Grattan | kgrattan6f@arstechnica.com | GA |
| 1/4/2023 | Crab - Dungeness, Whole, live | 42.64 | 95.27 | 59 | =($D8 - $C8) * $E8 | food | Feedspan | Price Hirschmann | phirschmannmh@cbsnews.com | TX |
| 1/4/2023 | Coffee Decaf Colombian | 19.54 | 37.20 | 50 | =($D9 - $C9) * $E9 | household | Blogtags | Ade Hancock | ahancock7i@spiegel.de | TX |
| 1/5/2023 | Sprouts Dikon | 63.64 | 72.64 | 86 | =($D10 - $C10) * $E10 | personal care | Flipstorm | Ade Bradneck | abradneckb6@istockphoto.com | AR |
The issue I'm having is that my formulas in the profit table on the Analysis sheet are all producing $0.00 there fore giving me a #DIVO error in my lower table as well.
I am currently working on this in google sheets.
Any help is greatly appreciated. thank you!
