Forum Discussion

deokars43's avatar
deokars43
Copper Contributor
Oct 29, 2022

Microsoft excel average function.

[ Spoiler ] I want help with Microsoft excel average function. Please help me with following conditions in excel. Data is attached below. 1 What is the average total USD rev/parent? 2 What...
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Nov 02, 2022

deokars43 

AVERAGE function

This link describes the formula syntax and usage of the AVERAGE  function in Microsoft Excel.

 

How To Calculate Averages in Excel (2 Methods and Examples)

...some more informations and exambles.

 

Excel Function Bible for Excel

examble files from the upper link.

 

Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.

 

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)

 

Resources

"}},"componentScriptGroups({\"componentId\":\"custom.widget.MicrosoftFooter\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/QueryHandler\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/EscalatedMessageBanner\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserLink\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserLink-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserRank\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserRank-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageTime\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageTime-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolvedBadge\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSubject\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSubject-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageBody\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageBody-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageCustomFields\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageCustomFields-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageReplyButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageReplyButton-1745505309764"}],"message({\"id\":\"message:3665648\"})":{"__ref":"ForumTopicMessage:message:3665648"},"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/ThreadedReplyList\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/tags/TagView/TagViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1745505309764"}],"cachedText({\"lastModified\":\"1745505309764\",\"locale\":\"en-US\",\"namespaces\":[\"components/attachments/AttachmentView/AttachmentViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1745505309764"}]},"CachedAsset:pages-1745487429212":{"__typename":"CachedAsset","id":"pages-1745487429212","value":[{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"UserBlogPermissions.Page","type":"COMMUNITY","urlPath":"/c/user-blog-permissions/page","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730142000000,"localOverride":null,"page":{"id":"AllEvents","type":"CUSTOM","urlPath":"/Events","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730142000000,"localOverride":null,"page":{"id":"CommunityHub.Page","type":"CUSTOM","urlPath":"/Directory","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730142000000,"localOverride":null,"page":{"id":"AllBlogs.Page","type":"CUSTOM","urlPath":"/blogs","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745487429212,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Deleted","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"false","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MMM dd yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":"en","possibleValues":["en-US"]}},"deleted":false},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"Category:category:microsoft365":{"__typename":"Category","id":"category:microsoft365","entityType":"CATEGORY","displayId":"microsoft365","nodeType":"category","depth":3,"title":"Microsoft 365","shortTitle":"Microsoft 365","parent":{"__ref":"Category:category:products-services"},"categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:top":{"__typename":"Category","id":"category:top","displayId":"top","nodeType":"category","depth":0,"title":"Top","entityType":"CATEGORY","shortTitle":"Top"},"Category:category:communities":{"__typename":"Category","id":"category:communities","displayId":"communities","nodeType":"category","depth":1,"parent":{"__ref":"Category:category:top"},"title":"Communities","entityType":"CATEGORY","shortTitle":"Communities"},"Category:category:products-services":{"__typename":"Category","id":"category:products-services","displayId":"products-services","nodeType":"category","depth":2,"parent":{"__ref":"Category:category:communities"},"title":"Products","entityType":"CATEGORY","shortTitle":"Products"},"Forum:board:ExcelGeneral":{"__typename":"Forum","id":"board:ExcelGeneral","entityType":"FORUM","displayId":"ExcelGeneral","nodeType":"board","depth":4,"conversationStyle":"FORUM","title":"Excel","description":"Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visit Microsoft Support Community.","avatar":null,"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:communities"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:products-services"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:microsoft365"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"boardPolicies":{"__typename":"BoardPolicies","canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}}},"shortTitle":"Excel","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"REVERSE_PUBLISH_TIME","repliesFormat":"threaded"},"tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":true,"tagType":"PRESET_ONLY"},"Rank:rank:37":{"__typename":"Rank","id":"rank:37","position":18,"name":"Copper Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:1589825":{"__typename":"User","id":"user:1589825","uid":1589825,"login":"deokars43","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"email":"","messagesCount":1,"biography":null,"topicsCount":1,"kudosReceivedCount":0,"kudosGivenCount":0,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-10-29T03:29:34.618-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"ForumTopicMessage:message:3665648":{"__typename":"ForumTopicMessage","uid":3665648,"subject":"Microsoft excel average function.","id":"message:3665648","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:1589825"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:3665648"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3665648"},"body@stripHtml({\"truncateLength\":200})":" [ Spoiler ] I want help with Microsoft excel average function. Please help me with following conditions in excel. Data is attached below. 1 What is the average total USD rev/parent? 2 What...","body@stringLength":"110325","rawBody":" 

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040  

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040
","kudosSumWeight":0,"postTime":"2022-10-29T03:44:20.726-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuMXwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:Formulas and Functions","text":"Formulas and Functions","time":"2016-06-24T14:00:56.974-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":52,"currentRevision":{"__ref":"Revision:revision:3665648_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":2604},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"customFields":[],"body":"
Spoiler
 

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040
Spoiler
 

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040
"},"Conversation:conversation:3665648":{"__typename":"Conversation","id":"conversation:3665648","solved":false,"topic":{"__ref":"ForumTopicMessage:message:3665648"},"lastPostingActivityTime":"2022-11-02T01:46:16.396-07:00","lastPostTime":"2022-11-02T01:46:16.396-07:00","unreadReplyCount":1,"isSubscribed":false},"ModerationData:moderation_data:3665648":{"__typename":"ModerationData","id":"moderation_data:3665648","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"Revision:revision:3665648_1":{"__typename":"Revision","id":"revision:3665648_1","lastEditTime":"2022-10-29T03:44:20.726-07:00"},"ForumReplyMessage:message:3667905":{"__typename":"ForumReplyMessage","id":"message:3667905","conversation":{"__ref":"Conversation:conversation:3665648"},"author":{"__ref":"User:user:722750"},"revisionNum":1,"uid":3667905,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: Microsoft excel average function.","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3667905"},"parent":{"__ref":"ForumTopicMessage:message:3665648"},"body":"

deokars43 

AVERAGE function

This link describes the formula syntax and usage of the AVERAGE  function in Microsoft Excel.

 

How To Calculate Averages in Excel (2 Methods and Examples)

...some more informations and exambles.

 

Excel Function Bible for Excel

examble files from the upper link.

 

Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.

 

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)

 

","body@stringLength":"1888","rawBody":"

 

AVERAGE function

This link describes the formula syntax and usage of the AVERAGE  function in Microsoft Excel.

 

How To Calculate Averages in Excel (2 Methods and Examples)

...some more informations and exambles.

 

Excel Function Bible for Excel

examble files from the upper link.

 

Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.

 

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)

 

","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-11-02T01:46:16.396-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"AttachmentEdge","cursor":"MjUuMXwyLjF8b3w1fF9OVl98MQ","node":{"__ref":"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber1\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/1/AVERAGEIF.xlsm\"}"}},{"__typename":"AttachmentEdge","cursor":"MjUuMXwyLjF8b3w1fF9OVl98Mg","node":{"__ref":"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber2\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/2/AVERAGE.xlsm\"}"}},{"__typename":"AttachmentEdge","cursor":"MjUuMXwyLjF8b3w1fF9OVl98Mw","node":{"__ref":"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber3\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/3/AVERAGEIFS.xlsm\"}"}},{"__typename":"AttachmentEdge","cursor":"MjUuMXwyLjF8b3w1fF9OVl98NA","node":{"__ref":"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber4\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/4/AVERAGEA.xlsm\"}"}},{"__typename":"AttachmentEdge","cursor":"MjUuMXwyLjF8b3w1fF9OVl98NQ","node":{"__ref":"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber5\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/5/DATEVALUE.xlsm\"}"}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:3667905_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":2564},"visibilityScope":"PUBLIC","isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[],"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1744326567586":{"__typename":"CachedAsset","id":"theme:customTheme1-1744326567586","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"favicon-1730836283320.png","imageLastModified":"1730836286415","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"favicon-1730836271365.png","imageLastModified":"1730836274203","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1300px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"3px","borderRadius":"3px","borderRadiusLg":"5px","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"700","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.16)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.12)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.3)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.3)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"var(--lia-bs-link-color)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#4099E2","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#148563","blogColor":"#1CBAA0","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#4C6B90","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#717171","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#0069D4","secondary":"#333333","bodyText":"#1E1E1E","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#BC341B","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#D3F5A4","#243A5E"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Segoe UI","fontStyle":"NORMAL","fontWeight":"400","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"10px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"10px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"Segoe UI","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"Segoe UI","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"300","__typename":"FontStyleData"},{"style":"NORMAL","weight":"600","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"}],"assetNames":["SegoeUI-normal-400.woff2","SegoeUI-normal-300.woff2","SegoeUI-normal-600.woff2","SegoeUI-normal-700.woff2","SegoeUI-italic-400.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"MWF Fluent Icons","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"}],"assetNames":["MWFFluentIcons-normal-400.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1745505309764","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1745505309764","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:o365.prod:pages/forums/ForumMessagePage:board:ExcelGeneral-1745502712750":{"__typename":"CachedAsset","id":"quilt:o365.prod:pages/forums/ForumMessagePage:board:ExcelGeneral-1745502712750","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"section-1733174818610","layout":"ONE_COLUMN","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"OneColumnQuiltSection","columnMap":{"main":[],"__typename":"OneSectionColumns"}},{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"custom.widget.Featured_Resources","className":null,"props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":true,"title":"Resources","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1745505309764","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived","section.TqVYTs.title":"Forum Discussion"},"localOverride":false},"CachedAsset:quiltWrapper:o365.prod:Common:1745505310164":{"__typename":"CachedAsset","id":"quiltWrapper:o365.prod:Common:1745505310164","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"className":"QuiltComponent_lia-component-edit-mode__0nCcm","links":{"sideLinks":[],"mainLinks":[{"children":[],"linkType":"INTERNAL","id":"gxcuf89792","params":{},"routeName":"CommunityPage"},{"children":[],"linkType":"EXTERNAL","id":"external-link","url":"/Directory","target":"SELF"},{"children":[{"linkType":"INTERNAL","id":"microsoft365","params":{"categoryId":"microsoft365"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"windows","params":{"categoryId":"Windows"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"Common-microsoft365-copilot-link","params":{"categoryId":"Microsoft365Copilot"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-teams","params":{"categoryId":"MicrosoftTeams"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-securityand-compliance","params":{"categoryId":"microsoft-security"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"azure","params":{"categoryId":"Azure"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"Common-content_management-link","params":{"categoryId":"Content_Management"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"exchange","params":{"categoryId":"Exchange"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"windows-server","params":{"categoryId":"Windows-Server"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"outlook","params":{"categoryId":"Outlook"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-endpoint-manager","params":{"categoryId":"microsoftintune"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"external-link-2","url":"/Directory","target":"SELF"}],"linkType":"EXTERNAL","id":"communities","url":"/","target":"BLANK"},{"children":[{"linkType":"INTERNAL","id":"a-i","params":{"categoryId":"AI"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"education-sector","params":{"categoryId":"EducationSector"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"partner-community","params":{"categoryId":"PartnerCommunity"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"i-t-ops-talk","params":{"categoryId":"ITOpsTalk"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"healthcare-and-life-sciences","params":{"categoryId":"HealthcareAndLifeSciences"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-mechanics","params":{"categoryId":"MicrosoftMechanics"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"public-sector","params":{"categoryId":"PublicSector"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"s-m-b","params":{"categoryId":"MicrosoftforNonprofits"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"io-t","params":{"categoryId":"IoT"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"startupsat-microsoft","params":{"categoryId":"StartupsatMicrosoft"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"driving-adoption","params":{"categoryId":"DrivingAdoption"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"external-link-1","url":"/Directory","target":"SELF"}],"linkType":"EXTERNAL","id":"communities-1","url":"/","target":"SELF"},{"children":[],"linkType":"EXTERNAL","id":"external","url":"/Blogs","target":"SELF"},{"children":[],"linkType":"EXTERNAL","id":"external-1","url":"/Events","target":"SELF"},{"children":[{"linkType":"INTERNAL","id":"microsoft-learn-1","params":{"categoryId":"MicrosoftLearn"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-learn-blog","params":{"boardId":"MicrosoftLearnBlog","categoryId":"MicrosoftLearn"},"routeName":"BlogBoardPage"},{"linkType":"EXTERNAL","id":"external-10","url":"https://learningroomdirectory.microsoft.com/","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-3","url":"https://docs.microsoft.com/learn/dynamics365/?WT.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-4","url":"https://docs.microsoft.com/learn/m365/?wt.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-5","url":"https://docs.microsoft.com/learn/topics/sci/?wt.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-6","url":"https://docs.microsoft.com/learn/powerplatform/?wt.mc_id=techcom_header-webpage-powerplatform","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-7","url":"https://docs.microsoft.com/learn/github/?wt.mc_id=techcom_header-webpage-github","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-8","url":"https://docs.microsoft.com/learn/teams/?wt.mc_id=techcom_header-webpage-teams","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-9","url":"https://docs.microsoft.com/learn/dotnet/?wt.mc_id=techcom_header-webpage-dotnet","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-2","url":"https://docs.microsoft.com/learn/azure/?WT.mc_id=techcom_header-webpage-m365","target":"BLANK"}],"linkType":"INTERNAL","id":"microsoft-learn","params":{"categoryId":"MicrosoftLearn"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"community-info-center","params":{"categoryId":"Community-Info-Center"},"routeName":"CategoryPage"}]},"style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","controllerHighlightColor":"hsla(30, 100%, 50%)","linkFontWeight":"400","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkBoxShadowHover":"none","linkFontSize":"14px","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","hamburgerColor":"var(--lia-nav-controller-icon-color)","linkTextBorderBottom":"none","brandLogoHeight":"30px","linkBgHoverColor":"transparent","linkLetterSpacing":"normal","collapseMenuDividerOpacity":0.16,"dropdownPaddingBottom":"15px","paddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","collapseMenuDividerBg":"var(--lia-nav-link-color)","linkColor":"var(--lia-bs-body-color)","linkJustifyContent":"flex-start","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-body-color)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-body-color)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","linkPaddingX":"10px","linkPaddingY":"5px","paddingTop":"15px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkBgColor":"transparent","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":false,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"linkTextColor":"var(--lia-bs-gray-700)"},"__typename":"QuiltComponent"},{"id":"custom.widget.community_banner","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":false,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"},{"id":"custom.widget.HeroBanner","props":{"widgetVisibility":"signedInOrAnonymous","usePageWidth":false,"useTitle":true,"cMax_items":3,"useBackground":false,"title":"","lazyLoad":false,"widgetChooser":"custom.widget.HeroBanner"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"custom.widget.MicrosoftFooter","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1745505309764","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:component:custom.widget.community_banner-en-1744400827777":{"__typename":"CachedAsset","id":"component:custom.widget.community_banner-en-1744400827777","value":{"component":{"id":"custom.widget.community_banner","template":{"id":"community_banner","markupLanguage":"HANDLEBARS","style":".community-banner {\n a.top-bar.btn {\n top: 0px;\n width: 100%;\n z-index: 999;\n text-align: center;\n left: 0px;\n background: #0068b8;\n color: white;\n padding: 10px 0px;\n display: block;\n box-shadow: none !important;\n border: none !important;\n border-radius: none !important;\n margin: 0px !important;\n font-size: 14px;\n }\n}\n","texts":null,"defaults":{"config":{"applicablePages":[],"description":"community announcement text","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.community_banner","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"community announcement text","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_community_banner_community-banner_1x9u2_1 {\n a.custom_widget_community_banner_top-bar_1x9u2_2.custom_widget_community_banner_btn_1x9u2_2 {\n top: 0;\n width: 100%;\n z-index: 999;\n text-align: center;\n left: 0;\n background: #0068b8;\n color: white;\n padding: 0.625rem 0;\n display: block;\n box-shadow: none !important;\n border: none !important;\n border-radius: none !important;\n margin: 0 !important;\n font-size: 0.875rem;\n }\n}\n","tokens":{"community-banner":"custom_widget_community_banner_community-banner_1x9u2_1","top-bar":"custom_widget_community_banner_top-bar_1x9u2_2","btn":"custom_widget_community_banner_btn_1x9u2_2"}},"form":null},"localOverride":false},"CachedAsset:component:custom.widget.HeroBanner-en-1744400827777":{"__typename":"CachedAsset","id":"component:custom.widget.HeroBanner-en-1744400827777","value":{"component":{"id":"custom.widget.HeroBanner","template":{"id":"HeroBanner","markupLanguage":"REACT","style":null,"texts":{"searchPlaceholderText":"Search this community","followActionText":"Follow","unfollowActionText":"Following","searchOnHoverText":"Please enter your search term(s) and then press return key to complete a search.","blogs.sidebar.pagetitle":"Latest Blogs | Microsoft Tech Community","followThisNode":"Follow this node","unfollowThisNode":"Unfollow this node"},"defaults":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[{"id":"max_items","dataType":"NUMBER","list":false,"defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"control":"INPUT","__typename":"PropDefinition"}],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.HeroBanner","form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"},"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[{"id":"max_items","dataType":"NUMBER","list":false,"defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"control":"INPUT","__typename":"PropDefinition"}],"__typename":"ComponentProperties"},"form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"},"__typename":"Component","localOverride":false},"globalCss":null,"form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"}},"localOverride":false},"CachedAsset:component:custom.widget.Featured_Resources-en-1744400827777":{"__typename":"CachedAsset","id":"component:custom.widget.Featured_Resources-en-1744400827777","value":{"component":{"id":"custom.widget.Featured_Resources","template":{"id":"Featured_Resources","markupLanguage":"REACT","style":null,"texts":{"resourceTitle":"Title","titlePlaceholder":"Resource title","urlPlaceholder":"Resource URL","resourceUrl":"URL","addResource":"Add Resource","cancel":"Cancel","removeResource":"Remove Resource","error":"Error","itemNotSaved":"Item not saved. {message}","errorMessage":"An error occurred. Please try again."},"defaults":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Featured_Resources","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.MicrosoftFooter-en-1744400827777":{"__typename":"CachedAsset","id":"component:custom.widget.MicrosoftFooter-en-1744400827777","value":{"component":{"id":"custom.widget.MicrosoftFooter","template":{"id":"MicrosoftFooter","markupLanguage":"HANDLEBARS","style":".context-uhf {\n min-width: 280px;\n font-size: 15px;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing: inherit;\n }\n a.c-uhff-link {\n color: #616161;\n word-break: break-word;\n text-decoration: none;\n }\n &a:link,\n &a:focus,\n &a:hover,\n &a:active,\n &a:visited {\n text-decoration: none;\n color: inherit;\n }\n & div {\n font-family: 'Segoe UI', SegoeUI, 'Helvetica Neue', Helvetica, Arial, sans-serif;\n }\n}\n.c-uhff {\n background: #f2f2f2;\n margin: -1.5625;\n width: auto;\n height: auto;\n}\n.c-uhff-nav {\n margin: 0 auto;\n max-width: calc(1600px + 10%);\n padding: 0 5%;\n box-sizing: inherit;\n &:before,\n &:after {\n content: ' ';\n display: table;\n clear: left;\n }\n @media only screen and (max-width: 1083px) {\n padding-left: 12px;\n }\n .c-heading-4 {\n color: #616161;\n word-break: break-word;\n font-size: 15px;\n line-height: 20px;\n padding: 36px 0 4px;\n font-weight: 600;\n }\n .c-uhff-nav-row {\n .c-uhff-nav-group {\n display: block;\n float: left;\n min-height: 1px;\n vertical-align: text-top;\n padding: 0 12px;\n width: 100%;\n zoom: 1;\n &:first-child {\n padding-left: 0;\n @media only screen and (max-width: 1083px) {\n padding-left: 12px;\n }\n }\n @media only screen and (min-width: 540px) and (max-width: 1082px) {\n width: 33.33333%;\n }\n @media only screen and (min-width: 1083px) {\n width: 16.6666666667%;\n }\n ul.c-list.f-bare {\n font-size: 11px;\n line-height: 16px;\n margin-top: 0;\n margin-bottom: 0;\n padding-left: 0;\n list-style-type: none;\n li {\n word-break: break-word;\n padding: 8px 0;\n margin: 0;\n }\n }\n }\n }\n}\n.c-uhff-base {\n background: #f2f2f2;\n margin: 0 auto;\n max-width: calc(1600px + 10%);\n padding: 30px 5% 16px;\n &:before,\n &:after {\n content: ' ';\n display: table;\n }\n &:after {\n clear: both;\n }\n a.c-uhff-ccpa {\n font-size: 11px;\n line-height: 16px;\n float: left;\n margin: 3px 0;\n }\n a.c-uhff-ccpa:hover {\n text-decoration: underline;\n }\n ul.c-list {\n font-size: 11px;\n line-height: 16px;\n float: right;\n margin: 3px 0;\n color: #616161;\n li {\n padding: 0 24px 4px 0;\n display: inline-block;\n }\n }\n .c-list.f-bare {\n padding-left: 0;\n list-style-type: none;\n }\n @media only screen and (max-width: 1083px) {\n display: flex;\n flex-wrap: wrap;\n padding: 30px 24px 16px;\n }\n}\n\n.social-share {\n position: fixed;\n top: 60%;\n transform: translateY(-50%);\n left: 0;\n z-index: 1000;\n}\n\n.sharing-options {\n list-style: none;\n padding: 0;\n margin: 0;\n display: block;\n flex-direction: column;\n background-color: white;\n width: 43px;\n border-radius: 0px 7px 7px 0px;\n}\n.linkedin-icon {\n border-top-right-radius: 7px;\n}\n.linkedin-icon:hover {\n border-radius: 0;\n}\n.social-share-rss-image {\n border-bottom-right-radius: 7px;\n}\n.social-share-rss-image:hover {\n border-radius: 0;\n}\n\n.social-link-footer {\n position: relative;\n display: block;\n margin: -2px 0;\n transition: all 0.2s ease;\n}\n.social-link-footer:hover .linkedin-icon {\n border-radius: 0;\n}\n.social-link-footer:hover .social-share-rss-image {\n border-radius: 0;\n}\n\n.social-link-footer img {\n width: 40px;\n height: auto;\n transition: filter 0.3s ease;\n}\n\n.social-share-list {\n width: 40px;\n}\n.social-share-rss-image {\n width: 40px;\n}\n\n.share-icon {\n border: 2px solid transparent;\n display: inline-block;\n position: relative;\n}\n\n.share-icon:hover {\n opacity: 1;\n border: 2px solid white;\n box-sizing: border-box;\n}\n\n.share-icon:hover .label {\n opacity: 1;\n visibility: visible;\n border: 2px solid white;\n box-sizing: border-box;\n border-left: none;\n}\n\n.label {\n position: absolute;\n left: 100%;\n white-space: nowrap;\n opacity: 0;\n visibility: hidden;\n transition: all 0.2s ease;\n color: white;\n border-radius: 0 10 0 10px;\n top: 50%;\n transform: translateY(-50%);\n height: 40px;\n border-radius: 0 6px 6px 0;\n display: flex;\n align-items: center;\n justify-content: center;\n padding: 20px 5px 20px 8px;\n margin-left: -1px;\n}\n.linkedin {\n background-color: #0474b4;\n}\n.facebook {\n background-color: #3c5c9c;\n}\n.twitter {\n background-color: white;\n color: black;\n}\n.reddit {\n background-color: #fc4404;\n}\n.mail {\n background-color: #848484;\n}\n.bluesky {\n background-color: white;\n color: black;\n}\n.rss {\n background-color: #ec7b1c;\n}\n#RSS {\n width: 40px;\n height: 40px;\n}\n\n@media (max-width: 991px) {\n .social-share {\n display: none;\n }\n}\n","texts":{"New tab":"What's New","New 1":"Surface Laptop Studio 2","New 2":"Surface Laptop Go 3","New 3":"Surface Pro 9","New 4":"Surface Laptop 5","New 5":"Surface Studio 2+","New 6":"Copilot in Windows","New 7":"Microsoft 365","New 8":"Windows 11 apps","Store tab":"Microsoft Store","Store 1":"Account Profile","Store 2":"Download Center","Store 3":"Microsoft Store Support","Store 4":"Returns","Store 5":"Order tracking","Store 6":"Certified Refurbished","Store 7":"Microsoft Store Promise","Store 8":"Flexible Payments","Education tab":"Education","Edu 1":"Microsoft in education","Edu 2":"Devices for education","Edu 3":"Microsoft Teams for Education","Edu 4":"Microsoft 365 Education","Edu 5":"How to buy for your school","Edu 6":"Educator Training and development","Edu 7":"Deals for students and parents","Edu 8":"Azure for students","Business tab":"Business","Bus 1":"Microsoft Cloud","Bus 2":"Microsoft Security","Bus 3":"Dynamics 365","Bus 4":"Microsoft 365","Bus 5":"Microsoft Power Platform","Bus 6":"Microsoft Teams","Bus 7":"Microsoft Industry","Bus 8":"Small Business","Developer tab":"Developer & IT","Dev 1":"Azure","Dev 2":"Developer Center","Dev 3":"Documentation","Dev 4":"Microsoft Learn","Dev 5":"Microsoft Tech Community","Dev 6":"Azure Marketplace","Dev 7":"AppSource","Dev 8":"Visual Studio","Company tab":"Company","Com 1":"Careers","Com 2":"About Microsoft","Com 3":"Company News","Com 4":"Privacy at Microsoft","Com 5":"Investors","Com 6":"Diversity and inclusion","Com 7":"Accessiblity","Com 8":"Sustainibility"},"defaults":{"config":{"applicablePages":[],"description":"The Microsoft Footer","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.MicrosoftFooter","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"The Microsoft Footer","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_MicrosoftFooter_context-uhf_105bp_1 {\n min-width: 17.5rem;\n font-size: 0.9375rem;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing: inherit;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-link_105bp_12 {\n color: #616161;\n word-break: break-word;\n text-decoration: none;\n }\n &a:link,\n &a:focus,\n &a:hover,\n &a:active,\n &a:visited {\n text-decoration: none;\n color: inherit;\n }\n & div {\n font-family: 'Segoe UI', SegoeUI, 'Helvetica Neue', Helvetica, Arial, sans-serif;\n }\n}\n.custom_widget_MicrosoftFooter_c-uhff_105bp_12 {\n background: #f2f2f2;\n margin: -1.5625;\n width: auto;\n height: auto;\n}\n.custom_widget_MicrosoftFooter_c-uhff-nav_105bp_35 {\n margin: 0 auto;\n max-width: calc(100rem + 10%);\n padding: 0 5%;\n box-sizing: inherit;\n &:before,\n &:after {\n content: ' ';\n display: table;\n clear: left;\n }\n @media only screen and (max-width: 1083px) {\n padding-left: 0.75rem;\n }\n .custom_widget_MicrosoftFooter_c-heading-4_105bp_49 {\n color: #616161;\n word-break: break-word;\n font-size: 0.9375rem;\n line-height: 1.25rem;\n padding: 2.25rem 0 0.25rem;\n font-weight: 600;\n }\n .custom_widget_MicrosoftFooter_c-uhff-nav-row_105bp_57 {\n .custom_widget_MicrosoftFooter_c-uhff-nav-group_105bp_58 {\n display: block;\n float: left;\n min-height: 0.0625rem;\n vertical-align: text-top;\n padding: 0 0.75rem;\n width: 100%;\n zoom: 1;\n &:first-child {\n padding-left: 0;\n @media only screen and (max-width: 1083px) {\n padding-left: 0.75rem;\n }\n }\n @media only screen and (min-width: 540px) and (max-width: 1082px) {\n width: 33.33333%;\n }\n @media only screen and (min-width: 1083px) {\n width: 16.6666666667%;\n }\n ul.custom_widget_MicrosoftFooter_c-list_105bp_78.custom_widget_MicrosoftFooter_f-bare_105bp_78 {\n font-size: 0.6875rem;\n line-height: 1rem;\n margin-top: 0;\n margin-bottom: 0;\n padding-left: 0;\n list-style-type: none;\n li {\n word-break: break-word;\n padding: 0.5rem 0;\n margin: 0;\n }\n }\n }\n }\n}\n.custom_widget_MicrosoftFooter_c-uhff-base_105bp_94 {\n background: #f2f2f2;\n margin: 0 auto;\n max-width: calc(100rem + 10%);\n padding: 1.875rem 5% 1rem;\n &:before,\n &:after {\n content: ' ';\n display: table;\n }\n &:after {\n clear: both;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-ccpa_105bp_107 {\n font-size: 0.6875rem;\n line-height: 1rem;\n float: left;\n margin: 0.1875rem 0;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-ccpa_105bp_107:hover {\n text-decoration: underline;\n }\n ul.custom_widget_MicrosoftFooter_c-list_105bp_78 {\n font-size: 0.6875rem;\n line-height: 1rem;\n float: right;\n margin: 0.1875rem 0;\n color: #616161;\n li {\n padding: 0 1.5rem 0.25rem 0;\n display: inline-block;\n }\n }\n .custom_widget_MicrosoftFooter_c-list_105bp_78.custom_widget_MicrosoftFooter_f-bare_105bp_78 {\n padding-left: 0;\n list-style-type: none;\n }\n @media only screen and (max-width: 1083px) {\n display: flex;\n flex-wrap: wrap;\n padding: 1.875rem 1.5rem 1rem;\n }\n}\n.custom_widget_MicrosoftFooter_social-share_105bp_138 {\n position: fixed;\n top: 60%;\n transform: translateY(-50%);\n left: 0;\n z-index: 1000;\n}\n.custom_widget_MicrosoftFooter_sharing-options_105bp_146 {\n list-style: none;\n padding: 0;\n margin: 0;\n display: block;\n flex-direction: column;\n background-color: white;\n width: 2.6875rem;\n border-radius: 0 0.4375rem 0.4375rem 0;\n}\n.custom_widget_MicrosoftFooter_linkedin-icon_105bp_156 {\n border-top-right-radius: 7px;\n}\n.custom_widget_MicrosoftFooter_linkedin-icon_105bp_156:hover {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162 {\n border-bottom-right-radius: 7px;\n}\n.custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162:hover {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169 {\n position: relative;\n display: block;\n margin: -0.125rem 0;\n transition: all 0.2s ease;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169:hover .custom_widget_MicrosoftFooter_linkedin-icon_105bp_156 {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169:hover .custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162 {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169 img {\n width: 2.5rem;\n height: auto;\n transition: filter 0.3s ease;\n}\n.custom_widget_MicrosoftFooter_social-share-list_105bp_188 {\n width: 2.5rem;\n}\n.custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162 {\n width: 2.5rem;\n}\n.custom_widget_MicrosoftFooter_share-icon_105bp_195 {\n border: 2px solid transparent;\n display: inline-block;\n position: relative;\n}\n.custom_widget_MicrosoftFooter_share-icon_105bp_195:hover {\n opacity: 1;\n border: 2px solid white;\n box-sizing: border-box;\n}\n.custom_widget_MicrosoftFooter_share-icon_105bp_195:hover .custom_widget_MicrosoftFooter_label_105bp_207 {\n opacity: 1;\n visibility: visible;\n border: 2px solid white;\n box-sizing: border-box;\n border-left: none;\n}\n.custom_widget_MicrosoftFooter_label_105bp_207 {\n position: absolute;\n left: 100%;\n white-space: nowrap;\n opacity: 0;\n visibility: hidden;\n transition: all 0.2s ease;\n color: white;\n border-radius: 0 10 0 0.625rem;\n top: 50%;\n transform: translateY(-50%);\n height: 2.5rem;\n border-radius: 0 0.375rem 0.375rem 0;\n display: flex;\n align-items: center;\n justify-content: center;\n padding: 1.25rem 0.3125rem 1.25rem 0.5rem;\n margin-left: -0.0625rem;\n}\n.custom_widget_MicrosoftFooter_linkedin_105bp_156 {\n background-color: #0474b4;\n}\n.custom_widget_MicrosoftFooter_facebook_105bp_237 {\n background-color: #3c5c9c;\n}\n.custom_widget_MicrosoftFooter_twitter_105bp_240 {\n background-color: white;\n color: black;\n}\n.custom_widget_MicrosoftFooter_reddit_105bp_244 {\n background-color: #fc4404;\n}\n.custom_widget_MicrosoftFooter_mail_105bp_247 {\n background-color: #848484;\n}\n.custom_widget_MicrosoftFooter_bluesky_105bp_250 {\n background-color: white;\n color: black;\n}\n.custom_widget_MicrosoftFooter_rss_105bp_254 {\n background-color: #ec7b1c;\n}\n#custom_widget_MicrosoftFooter_RSS_105bp_1 {\n width: 2.5rem;\n height: 2.5rem;\n}\n@media (max-width: 991px) {\n .custom_widget_MicrosoftFooter_social-share_105bp_138 {\n display: none;\n }\n}\n","tokens":{"context-uhf":"custom_widget_MicrosoftFooter_context-uhf_105bp_1","c-uhff-link":"custom_widget_MicrosoftFooter_c-uhff-link_105bp_12","c-uhff":"custom_widget_MicrosoftFooter_c-uhff_105bp_12","c-uhff-nav":"custom_widget_MicrosoftFooter_c-uhff-nav_105bp_35","c-heading-4":"custom_widget_MicrosoftFooter_c-heading-4_105bp_49","c-uhff-nav-row":"custom_widget_MicrosoftFooter_c-uhff-nav-row_105bp_57","c-uhff-nav-group":"custom_widget_MicrosoftFooter_c-uhff-nav-group_105bp_58","c-list":"custom_widget_MicrosoftFooter_c-list_105bp_78","f-bare":"custom_widget_MicrosoftFooter_f-bare_105bp_78","c-uhff-base":"custom_widget_MicrosoftFooter_c-uhff-base_105bp_94","c-uhff-ccpa":"custom_widget_MicrosoftFooter_c-uhff-ccpa_105bp_107","social-share":"custom_widget_MicrosoftFooter_social-share_105bp_138","sharing-options":"custom_widget_MicrosoftFooter_sharing-options_105bp_146","linkedin-icon":"custom_widget_MicrosoftFooter_linkedin-icon_105bp_156","social-share-rss-image":"custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162","social-link-footer":"custom_widget_MicrosoftFooter_social-link-footer_105bp_169","social-share-list":"custom_widget_MicrosoftFooter_social-share-list_105bp_188","share-icon":"custom_widget_MicrosoftFooter_share-icon_105bp_195","label":"custom_widget_MicrosoftFooter_label_105bp_207","linkedin":"custom_widget_MicrosoftFooter_linkedin_105bp_156","facebook":"custom_widget_MicrosoftFooter_facebook_105bp_237","twitter":"custom_widget_MicrosoftFooter_twitter_105bp_240","reddit":"custom_widget_MicrosoftFooter_reddit_105bp_244","mail":"custom_widget_MicrosoftFooter_mail_105bp_247","bluesky":"custom_widget_MicrosoftFooter_bluesky_105bp_250","rss":"custom_widget_MicrosoftFooter_rss_105bp_254","RSS":"custom_widget_MicrosoftFooter_RSS_105bp_1"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1745505309764","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1745505309764","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"Category:category:Exchange":{"__typename":"Category","id":"category:Exchange","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Outlook":{"__typename":"Category","id":"category:Outlook","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Community-Info-Center":{"__typename":"Category","id":"category:Community-Info-Center","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:EducationSector":{"__typename":"Category","id":"category:EducationSector","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:DrivingAdoption":{"__typename":"Category","id":"category:DrivingAdoption","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Azure":{"__typename":"Category","id":"category:Azure","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Windows-Server":{"__typename":"Category","id":"category:Windows-Server","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftTeams":{"__typename":"Category","id":"category:MicrosoftTeams","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PublicSector":{"__typename":"Category","id":"category:PublicSector","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:IoT":{"__typename":"Category","id":"category:IoT","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:HealthcareAndLifeSciences":{"__typename":"Category","id":"category:HealthcareAndLifeSciences","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:ITOpsTalk":{"__typename":"Category","id":"category:ITOpsTalk","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftLearn":{"__typename":"Category","id":"category:MicrosoftLearn","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:MicrosoftLearnBlog":{"__typename":"Blog","id":"board:MicrosoftLearnBlog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:AI":{"__typename":"Category","id":"category:AI","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftMechanics":{"__typename":"Category","id":"category:MicrosoftMechanics","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftforNonprofits":{"__typename":"Category","id":"category:MicrosoftforNonprofits","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:StartupsatMicrosoft":{"__typename":"Category","id":"category:StartupsatMicrosoft","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PartnerCommunity":{"__typename":"Category","id":"category:PartnerCommunity","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Microsoft365Copilot":{"__typename":"Category","id":"category:Microsoft365Copilot","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Windows":{"__typename":"Category","id":"category:Windows","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Content_Management":{"__typename":"Category","id":"category:Content_Management","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:microsoft-security":{"__typename":"Category","id":"category:microsoft-security","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:microsoftintune":{"__typename":"Category","id":"category:microsoftintune","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"CachedAsset:text:en_US-components/community/Navbar-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1745505309764","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","gxcuf89792":"Tech Community","external-1":"Events","s-m-b":"Nonprofit Community","windows-server":"Windows Server","education-sector":"Education Sector","driving-adoption":"Driving Adoption","Common-content_management-link":"Content Management","microsoft-learn":"Microsoft Learn","s-q-l-server":"Content Management","partner-community":"Microsoft Partner Community","microsoft365":"Microsoft 365","external-9":".NET","external-8":"Teams","external-7":"Github","products-services":"Products","external-6":"Power Platform","communities-1":"Topics","external-5":"Microsoft Security","planner":"Outlook","external-4":"Microsoft 365","external-3":"Dynamics 365","azure":"Azure","healthcare-and-life-sciences":"Healthcare and Life Sciences","external-2":"Azure","microsoft-mechanics":"Microsoft Mechanics","microsoft-learn-1":"Community","external-10":"Learning Room Directory","microsoft-learn-blog":"Blog","windows":"Windows","i-t-ops-talk":"ITOps Talk","external-link-1":"View All","microsoft-securityand-compliance":"Microsoft Security","public-sector":"Public Sector","community-info-center":"Lounge","external-link-2":"View All","microsoft-teams":"Microsoft Teams","external":"Blogs","microsoft-endpoint-manager":"Microsoft Intune","startupsat-microsoft":"Startups at Microsoft","exchange":"Exchange","a-i":"AI and Machine Learning","io-t":"Internet of Things (IoT)","Common-microsoft365-copilot-link":"Microsoft 365 Copilot","outlook":"Microsoft 365 Copilot","external-link":"Community Hubs","communities":"Products"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1745505309764","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1745505309764","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1745505309764","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1745505309764","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1745505309764","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1745505309764","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageDeepLink-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1745505309764","value":{"viewFullDiscussion@board:FORUM":"View Full Discussion ({repliesCount} Replies)","viewFullDiscussion@board:BLOG":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:TKB":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:IDEA":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:OCCASION":"View Full Discussion ({repliesCount} Comments)","showParents@board:FORUM":"Show Parent Replies","showParents@board:BLOG":"Show Parent Comments","showParents@board:TKB":"Show Parent Comments","showParents@board:IDEA":"Show Parent Comments","showParents@board:OCCASION":"Show Parent Comments"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1745505309764","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1745505309764","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1745505309764","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1745505309764","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1745505309764","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1745505309764","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1745505309764","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1745505309764","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1745505309764","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1745505309764","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1745505309764","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1745505309764","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"Rank:rank:31":{"__typename":"Rank","id":"rank:31","position":12,"name":"Gold Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:722750":{"__typename":"User","id":"user:722750","uid":722750,"login":"NikolinoDE","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/dS03MjI3NTAtMjU2NTAwaTlFOUZGMTI1OUEyRjU4OTc"},"rank":{"__ref":"Rank:rank:31"},"email":"","messagesCount":7416,"biography":null,"topicsCount":19,"kudosReceivedCount":1199,"kudosGivenCount":233,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-07-08T12:46:57.742-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":529},"ModerationData:moderation_data:3667905":{"__typename":"ModerationData","id":"moderation_data:3667905","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber1\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/1/AVERAGEIF.xlsm\"}":{"__typename":"Attachment","id":"attachment:message3667905AttachmentNumber1","filename":"AVERAGEIF.xlsm","filesize":31665,"contentType":"application/vnd.ms-excel.sheet.macroEnabled.12","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/1/AVERAGEIF.xlsm"},"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber2\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/2/AVERAGE.xlsm\"}":{"__typename":"Attachment","id":"attachment:message3667905AttachmentNumber2","filename":"AVERAGE.xlsm","filesize":75500,"contentType":"application/vnd.ms-excel.sheet.macroEnabled.12","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/2/AVERAGE.xlsm"},"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber3\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/3/AVERAGEIFS.xlsm\"}":{"__typename":"Attachment","id":"attachment:message3667905AttachmentNumber3","filename":"AVERAGEIFS.xlsm","filesize":29208,"contentType":"application/vnd.ms-excel.sheet.macroEnabled.12","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/3/AVERAGEIFS.xlsm"},"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber4\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/4/AVERAGEA.xlsm\"}":{"__typename":"Attachment","id":"attachment:message3667905AttachmentNumber4","filename":"AVERAGEA.xlsm","filesize":37548,"contentType":"application/vnd.ms-excel.sheet.macroEnabled.12","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/4/AVERAGEA.xlsm"},"Attachment:{\"id\":\"attachment:message3667905AttachmentNumber5\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/5/DATEVALUE.xlsm\"}":{"__typename":"Attachment","id":"attachment:message3667905AttachmentNumber5","filename":"DATEVALUE.xlsm","filesize":38095,"contentType":"application/vnd.ms-excel.sheet.macroEnabled.12","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/169225/5/DATEVALUE.xlsm"},"Revision:revision:3667905_1":{"__typename":"Revision","id":"revision:3667905_1","lastEditTime":"2022-11-02T01:46:16.396-07:00"},"QueryVariables:ReplyList:message:3667905:1":{"__typename":"QueryVariables","id":"ReplyList:message:3667905:1","value":{"id":"message:3667905","first":10,"sorts":{"postTime":{"direction":"DESC"}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"postTime":{"direction":"DESC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1745505309764","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1745505309764","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1745505309764","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1745505309764","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1745505309764","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1745505309764":{"__typename":"CachedAsset","id":"text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1745505309764","value":{"errorTitle":"Failed!","previewFile":"Preview File","downloadFile":"Download File {name}","removeFile":"Remove File {name}","errorBadExtension":"This file does not have a valid extension. \"{extensions}\" are the valid extensions.","errorFileEmpty":"This file is empty or does not exist.","errorTooLarge":"The maximum file size is: {maxFileSize}.","errorTooMany":"Too many attachments. The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"excelgeneral","messageSubject":"microsoft-excel-average-function-","messageId":"3665648","replyId":"3667905"},"buildId":"HEhyUrv5OXNBIbfCLaOrw","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"o365","openTelemetryServiceVersion":"25.1.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/external/components/ExternalComponent.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx","./components/attachments/AttachmentView/AttachmentView.tsx","./components/attachments/AttachmentView/AttachmentViewChip/AttachmentViewChip.tsx"],"appGip":true,"scriptLoader":[{"id":"analytics","src":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/pagescripts/1730819800000/analytics.js?page.id=ForumReplyPage&entity.id=board%3Aexcelgeneral&entity.id=message%3A3667905","strategy":"afterInteractive"}]}