## Archive for the ‘SUM function’ Category

Is it possible to quickly select all empty cells and then sum cells above to next empty cell? Can I have […]

Comments(0) Filed in categories: Excel, SUM function, SUMPRODUCT function

The SUM function in excel allows you to add values, the function returns the sum in the cell it is […]

Comments(0) Filed in categories: Excel, SUM function

This article explains how to build an array formula that sums ranges. Example, I want to know how to calculate […]

Comments(2) Filed in categories: Excel, SUM function

Here comes another post about the MMULT function, today I made a dynamic scoreboard. There are five women competing and there […]

Comments(7) Filed in categories: Count values, Excel, MMULT function, SUM function

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

Comments(13) Filed in categories: Excel, MMULT function, Permutations, SUM function

Question: I have a long table The key is actually col B&C BUT…sometime there are few rows with same key […]

Comments(0) Filed in categories: Excel, Invoice, SUM function, Unique distinct values

I created/modified an udf to solve his question: Find positive and negative amounts that net to zero in excel Question:I would […]

Comments(5) Filed in categories: Excel, SUM function

This article describes how to find a sum from a range of numbers using a user defined function. Let´s see […]

Comments(2) Filed in categories: Excel, Finance, SUM function

Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]

Comments(48) Filed in categories: Combinations, Excel, Solver, SUM function

Here is a follow up to this previous post: Vlookup with 2 or more lookup criteria and return multiple matches […]

Comments(1) Filed in categories: Excel, SUM function, Vlookup

Question: How do I sum all values in a range where adjacent cell value equals a criterion? The criterion is […]

Comments(19) Filed in categories: Excel, SUM function

In this post, I will provide a formula to sum values in column (Qty) where an column (Date) meets two […]

Comments(27) Filed in categories: Excel, SUM function

Question: How do I sum values only if a unique value exists in another column? Answer: Formula in D13: =SUM(IF(COUNTIF(List1, […]

Comments(0) Filed in categories: Excel, SUM function, Unique values

I will now demonstrate with the following table how to add check-boxes and sum enabled check-boxes using a formula. Add […]

Comments(2) Filed in categories: Check-boxes, Excel, SUM function

To sum a column use: =SUM(A1:A20). But what if the column is filtered? As you can see , in the […]

Comments(0) Filed in categories: Excel, SUM function