ed.ayers315
Board Regular
- Joined
- Dec 14, 2009
- Messages
- 166
I have encountered additional issues and need help from the experts.
X2 should only total if there are more than 1 instance of Recipe 1 used in a single day. This is determined in column J
O55 should be 0 because there was only 1 Recipe 1 used that day. I would like to change that from using the "Recipe 1" range name to pulling in the actual usage for that instance showing in column H "Total Recorded.
I have this spreadsheet on Sky Drive: https://skydrive.live.com/redir.aspx?cid=a6ca4d53a10e5303&resid=A6CA4D53A10E5303!235
X2 should only total if there are more than 1 instance of Recipe 1 used in a single day. This is determined in column J
O55 should be 0 because there was only 1 Recipe 1 used that day. I would like to change that from using the "Recipe 1" range name to pulling in the actual usage for that instance showing in column H "Total Recorded.
I have this spreadsheet on Sky Drive: https://skydrive.live.com/redir.aspx?cid=a6ca4d53a10e5303&resid=A6CA4D53A10E5303!235
Excel Workbook | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |||
51 | 2025 | 175 | 175 | 100 | 0 | 0 | 1 | |||||||||||||
52 | Product Used | Total Recorded | Survey Target | 29-Apr-2011 23:54:19 | Day | Recipe 1: | Recipe 2: | Recipe 3: | Recipe 4: | Recipe 5: | Recipe 6: | 1 | Recipe 1: | |||||||
53 | Recipe 1: | 25 | 25 | 50:09.0 | 29 | 5:00:00 | 53 | 1 | ||||||||||||
54 | 29 | 54 | 1 | |||||||||||||||||
55 | 29-Apr-2011 23:58:29 | 29 | 1 | 50 | 0 | 0 | 0 | 0 | 0 | 55 | 2 | 2 | ||||||||
56 | Recipe 1: | 19 | 25 | 0:04:10 | 30 | 5:00:00 | 56 | 2 | ||||||||||||
57 | 30 | 57 | 2 | |||||||||||||||||
58 | 30-Apr-2011 01:23:32 | 30 | 58 | 2 | ||||||||||||||||
Sheet1 |