Excel SUMIFS formula with multiple criteria in the same column

Very often, you will have to construct an excel SUMIFS formula with multiple criteria based on the same column values. Which is equivalent to the SUMIFS formula with multiple OR conditions. I guess you may have tried it…but find it difficult to achieve. Because the Excel SUMIFS formula does not have any such option. So let me explain how to achieve this using a few tricks. Excel SUMIFS with multiple criteria If you are reading this article then I’d assume you already know how to use SUMFIS in general, if not then here is my SUMIFS tutorial....

February 21, 2022 · Sudheer Tammini

51 Best Excel Tips and Tricks to skyrocket your productivity [2022 update]

I went from being a bad excel user to a professional after learning these excel tips and tricks. The good news is I’m going to teach you these tips using simple and real-life examples. There has been so much written about the best excel tips and tricks on the internet, I could literally find 2,23,000 exact matches by the time of writing this article. So, I don’t want to write one more article with all the garbage....

December 12, 2021 · Sudheer Tammini

11 Tips to Reduce Excel file size by at least 20%

How do I reduce excel file size? The most often asked question. Well, in this step by step tutorial I’ll walk you through various best practices to reduce excel file size and how to optimize excel workbook to work better. #1 Save your workbooks in a Binary format This is my favorite tip and it always works great. I have been recommending this tip since I started writing this blog....

August 6, 2018 · Sudheer Tammini

How Planned vs Actual Chart In Excel Can Ease Your Pain

The planned vs Actual chart in excel will give you an edge over traditional tabular analysis. In fancy terms, we call it as a Budget vs Actual analysis or Variance analysis. Indeed, it’s quite essential to assess the performance of our plans against actual results periodically. So, in this step by step tutorial, we are going to take a look at how to build planned vs actual graph in excel....

July 5, 2016 · Sudheer Tammini

The Step-by-Step Guide to Creating Excel Heat Map That will Impress Your Boss

Creating excel heat map is an art. You need to know which colour combinations work better for your scenarios. According to aresearch conducted by Prof. Richard Wiseman, “about 25% of people found documents with colours are easier to analyse”. In fact, colours can play a pivotal role in your analysis when you use it wisely. For example, if you’d like to highlight high-cost scenario then you might have to use Red, similarly Green for the low cost....

May 2, 2016 · Sudheer Tammini