Posted by jpluimers on 2020/03/31
As I need this one day:
To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:
=SUM(SUMIFS(E4:E11,D4:D11,{"complete","pending"}))
Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet

–jeroen
Like this:
Like Loading...
Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2019/06/28
I hardly print with Excel, so I always forget these two:
–jeroen
Like this:
Like Loading...
Posted in Excel, Office, Office 2011 for Mac, Office 2013, Power User | Leave a Comment »
Posted by jpluimers on 2018/10/29
For my link archive: [WayBack] Language Accessory Pack for Office – Office Support (short-link)
All supported languages for Office 2010, 2013 and 2066/newer versions.
–jeroen
Like this:
Like Loading...
Posted in Office, Office 2010, Office 2013, Office 2016, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2018/09/17
Steps to try first:
- Check
%windir%\Windowsupdate.log
(on my system, it did not reveal anything special)
- In an administrator command prompt, run
sfc /scannow
(which takes a few minutes to run)
- Reboot
- Run Clean Manager
%windir%\System32\cleanmgr.exe
(ensure to clean up update files: it can take tens of minutes to run)
- Reboot
- Download the SP1 files (I needed 32-bit x86)
- Install SP1 manually
- If it still hangs:
- In
Appwiz.cpl
try a “Repair” of the Office 2013 installation
- If it works: Reboot, otherwise:
- Uninstall Office 2013
- Disable the network adapter
- Reboot
- Check if KB3173424 is installed (check it with
Appwiz.cpl
)
- if not: download on a different machine, transfer over USB, install, then reboot
- Check ifKB3172614 is installed (which has a younger Windows Update Client)
- if not: downloadon a different machine, transfer over USB, install, then reboot
- Enable the network adapter
- Let Windows scan for updates and install them
- If you get an error 80070463 or 80070663: just reboot and retry the updates.
- Reboot
- Run Clean Manager
- Install Office 2013
- Reboot
- Let Windows scan for updates and install them
- Reboot
- Run Clean Manager
- Reboot
The KB3172614 should also alleviate long during (dozens of minutes) high CPU usage of svchost.exe and TiWorker.exe when searching for Windows updates.
Read the rest of this entry »
Like this:
Like Loading...
Posted in Office, Office 2013, Power User, Windows, Windows 8.1 | Leave a Comment »
Posted by jpluimers on 2018/05/11
If you use Outlook to check and manage your email, you can easily use it to check your Gmail account as well. You can set up your Gmail account to allow you to synchronize email across multiple machines using email clients instead of a browser.
Oh: you need to lower your Gmail security for Outlook 2013 as the latter isn’t up to par on security. For that, follow similar steps like in “the user name or password for imap.gmail is incorrect” – iPad, iPod or iPhone with iOS < 7.
–jeroen
Like this:
Like Loading...
Posted in GMail, Google, Office, Office 2013, Office 2016, Outlook, Power User | Leave a Comment »