glowinggal19
New Member
- Joined
- Apr 22, 2018
- Messages
- 1
sheet 1 - all sales total imported and sorted by date, category, designer, $ sold
sheet 2 - payouts, including % reduction forumlas = total payout to subcontractor
sheet 3 - Profit/Loss
Here is where I'm not sure how to code it. On Sheet 3, by month I have a row for totals of subcontractor payouts. A final sum- by month on sheet 3, but on sheet 2 dates are coded to come in from sheet 1 so anytime it's updated the totals are updated on sheet 2.
Currently I have the Sheet 2 coding to show the date as mmmm after import - how do I get my "if" statement to recognize this or read it from Sheet 1 to put in Sheet 3?
How should I write a formula for:
IF date from sheet 2 (but coding to grab from sheet 1), is January, total of all January final payouts on Sheet 3
sheet 2 - payouts, including % reduction forumlas = total payout to subcontractor
sheet 3 - Profit/Loss
Here is where I'm not sure how to code it. On Sheet 3, by month I have a row for totals of subcontractor payouts. A final sum- by month on sheet 3, but on sheet 2 dates are coded to come in from sheet 1 so anytime it's updated the totals are updated on sheet 2.
Currently I have the Sheet 2 coding to show the date as mmmm after import - how do I get my "if" statement to recognize this or read it from Sheet 1 to put in Sheet 3?
How should I write a formula for:
IF date from sheet 2 (but coding to grab from sheet 1), is January, total of all January final payouts on Sheet 3