In sheet 2 I have a list of product sales by region for 260 days of 2012. In sheet 1 I want to summarize the total of the product on a specific day. The formula I am using does not work.
I want to create a formula in Sheet1 to get total sales for Product1 on Day 1, Product2 on Day 1, etc. This is the formula I have but it is not working:
<colgroup><col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Any help is much appreciated!
I want to create a formula in Sheet1 to get total sales for Product1 on Day 1, Product2 on Day 1, etc. This is the formula I have but it is not working:
=SUM(IF('Sheet2'!$B$3:$B$10='Sheet1'!A2&$B$1,IF('Sheet2'!$C$1:$C$260='Sheet1'!A2&$B$1,'2012 Sales'!$C$3:$JC$113))) |
<colgroup><col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <tbody>
</tbody>
SHEET1 | Day #1 | Daily Sales | MTD Sales | YTD Sales |
Product1 | 25 | |||
Product2 | 19 | |||
Product3 | 18 | |||
Etc |
<tbody>
</tbody>
SHEET2 | Date | 1/2/2012 | 1/3/2012 | 1/4/2012 | 1/5/2012 | 1/6/2012 | 1/7/2012 | 1/8/2012 | 1/9/2012 |
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
Region1 | Product1 | 20 | 10 | 15 | 10 | 10 | 10 | 10 | 10 |
Region1 | Product2 | 13 | 15 | 15 | 15 | 15 | 15 | 15 | 15 |
Region1 | Product3 | 10 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
Region2 | Product1 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Region2 | Product2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
Region2 | Product3 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |
Etc | Etc | ||||||||
Etc | Etc |
<tbody>
</tbody>
Any help is much appreciated!