KateWantsToLearn
New Member
- Joined
- Jun 30, 2010
- Messages
- 8
Hi Excel Wizards!
I am working with a colleague who doesn't have access to Excel 2007, so I can't use Sumif's to solve this, and I can't add a subtotal line (long story) to the data. Can someone please help me to solve this problem?
I have data with months across the top (columns B:M in row 2) and then lines down the left side (rows 4:9, lets say). So under January (B) it might have $10 in row 4, $50 in row 7. And in March (D) it might have $5 in row 6.
Below that I have weeks of the year set out across a row, with a line underneath indicating "End of month" for the weeks on which a month ends. For instance, the week ending Saturday, 2/5/2011 would say "End of month" because 1/31/2011 falls during that week.
I want to have a line below that will do a sumif() of rows 4:9 if the month end is equal to the month in row 2. So January in my example above would give me $60. I did =and(if(...it is a month end week....),sumif(months, the month end month equals the month in row 2, sum range b4:m9), but it only returns the values in row 4.
Any ideas? I can post a sample Excel file is someone tells me how to.
I am working with a colleague who doesn't have access to Excel 2007, so I can't use Sumif's to solve this, and I can't add a subtotal line (long story) to the data. Can someone please help me to solve this problem?
I have data with months across the top (columns B:M in row 2) and then lines down the left side (rows 4:9, lets say). So under January (B) it might have $10 in row 4, $50 in row 7. And in March (D) it might have $5 in row 6.
Below that I have weeks of the year set out across a row, with a line underneath indicating "End of month" for the weeks on which a month ends. For instance, the week ending Saturday, 2/5/2011 would say "End of month" because 1/31/2011 falls during that week.
I want to have a line below that will do a sumif() of rows 4:9 if the month end is equal to the month in row 2. So January in my example above would give me $60. I did =and(if(...it is a month end week....),sumif(months, the month end month equals the month in row 2, sum range b4:m9), but it only returns the values in row 4.
Any ideas? I can post a sample Excel file is someone tells me how to.
