Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

SUM

Aggregate with OR Logic

By Jeff Lenning | December 14, 2020 |

The family of IFS functions, such as SUMIFS and COUNTIFS, use AND logic when evaluating multiple conditions. In other words, all conditions must be true to be included. And generally, this logic works well. However, there are situations when we’d like to use OR logic instead. That is, any of the conditions can be true…

Read More

Quickly Insert the SUM Function

By Jeff Lenning | October 31, 2013 |

Let’s face it, Excel users probably insert the SUM function more often than any other function. As you know, we can improve our productivity by keeping our hands on our keyboards. This post discusses my favorite keyboard shortcut for inserting the SUM function. Keyboard Shortcut The SUM function is easily inserted into a workbook with…

Read More