XL Learner
New Member
- Joined
- Oct 8, 2007
- Messages
- 20
Hello,
I am trying to conditionally sum numbers over 52 worksheets based upon up to 3 conditions. One condition is a date, the other condition is a company name. Right now I am using only 2 conditions but may add a third.
I am using an array formula to get the result I need for that worksheet. Here it is:
{=SUM((I4:M4=V5)*(F6:F42=V4)*I6:M42)}
My question is this.....How do I get the results I need for all 52 worksheets in one formula?
All information on all worksheets are in the exact same cell references.
My goal is to have a reporting worksheet that has all 365 days of the year and depending on what company is is in the first cell; all dates have the respective number that for that day that is contained on another worksheet.
I know my description is a little vuage, if I need to clarify, please let me know.
I am trying to conditionally sum numbers over 52 worksheets based upon up to 3 conditions. One condition is a date, the other condition is a company name. Right now I am using only 2 conditions but may add a third.
I am using an array formula to get the result I need for that worksheet. Here it is:
{=SUM((I4:M4=V5)*(F6:F42=V4)*I6:M42)}
My question is this.....How do I get the results I need for all 52 worksheets in one formula?
All information on all worksheets are in the exact same cell references.
My goal is to have a reporting worksheet that has all 365 days of the year and depending on what company is is in the first cell; all dates have the respective number that for that day that is contained on another worksheet.
I know my description is a little vuage, if I need to clarify, please let me know.