User Profile
Durwood
Copper Contributor
Joined Nov 10, 2022
User Widgets
Recent Discussions
Maximum number of arrays to use with SUMIFS
Hi, I have a situation where I need to sum a column where it would be ideal if SUMIFS could use three (or more) arrays in M365. The following sample SUMIFS nested in a sum statement works fine, but I'd like to add a third column/array after {"D";"E"}. Can anyone tell me if this can be done or should I just use multiple SUMIFS formulas without arrays. I've tried researching this and the closest answer is to use the semi-colon in the second array. However, I'm unable to find information about adding a third array. =SUM(SUMIFS(DATA[Eligibility], DATA[Location], {"A","B"}, DATA[SchoolType], {"D";"E"})) Appreciate your thoughts and suggestions.Solved93Views0likes1CommentUpdates App Report
Using the ‘updates app’, I created a weekly request for getting input to the team meeting agenda. It’s great at collecting requests, but not so good providing a single location to easily view team member submissions in a single ‘report’ for that week. I can go into Forms and extract/export to excel, but it’s kind of a clunky solution. Plus, it looks like the export won’t aggregate weekly responses by due date. I’m new to the MS Teams apps. Perhaps there’s a better app than Updates? Any suggestions and/or direction is appreciated. Note - I’m an end user, not an IT Admin. Thanks!Solved1.5KViews0likes1Comment
Recent Blog Articles
No content to show