Hey all!
Got a large workbook that tracks certain activities throughout the entire year. Each day is broken down into 4 columns, of which 3 require formulas to calculate the total of a certain type of activity for that day for a certain person. I have tried two formulas to try to get what i want but once i use them for the entire year the workbook becomes unusable. The first one utilizes array formulas so that quickly becomes unusable after pasting it to only a few days. The second formula becomes unusable after pasting to a couple months. The SUMIFS uses the actual dataset and the array formulas uses pivot tables on a separate sheet to lookup values. The calendar will have between 20-80 rows depending on how many people are active. So 3 columns x 365 days x 80 people= 87000 cells that need formulas..... can anyone think of formulas that could be utilized that would still allow the workbook to be usable? I could add helped columns to the dataset if that assists.
{=IFERROR(INDEX('Production Pivot Tables'!$A$5:$C$5959,MATCH(1,('Production Pivot Tables'!B:B=B8)*('Production Pivot Tables'!A:A=J$7),0),3),0)}
=SUMIFS('Trending Log Import'!$AA:$AA,'Trending Log Import'!$T:$T,"*Task*",'Trending Log Import'!$N:$N,$A8,'Trending Log Import'!$C:$C,'2015 Central Region Production'!L$7)
Thanks and let me know if this doesnt make sense.
Bookmarks