Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function. To count numbers or dates that fall within a range (such as greater than 9000 and at the same time less than 22500), you can use the COUNTIFS function. Alternately, you can use SUMPRODUCT too.

Things to try first. Try these things first to help you fix or narrow down the connection problem. Run Get Help to troubleshoot and fix common connection problems. Right click the network icon in the right side of the taskbar and select Diagnose network problems or open Get Help for Network & Internet

Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.

Sign in to www.office.com from a web browser and start using the apps on the web or access other web services associated with your account such as OneDrive.. How you sign in to an installed Office app depends on your device.

Learn how to use your voice to create and edit documents in Word with the Dictate feature. Find out how to enable, customize, and troubleshoot Dictation.

Use the Windows Quick Assist app to get help with a computer problem from family or friends or help them out. Quick Assist uses a remote connection, so remember to only use it with people you trust, since they can see your computer screen or control your PC (if you allow it).

To make substantial layout changes to a PivotTable or its various fields, you can use one of three forms: Compact form displays items from different row area fields in one column and uses indentation to distinguish between the items from different fields.Row labels take up less space in compact form, which leaves more room for numeric data.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Billing & payments. Your dashboard is also where you can: Buy, renew, or cancel a subscription.