## Archive for the ‘Sum’ Category

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, Functions, Sum

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

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, Sum

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, Permutations, Sum

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, Sum, 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

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

Introduction What is unique distinct values? Unique distinct values are all values but duplicates are merged into one value. Count […]

Comments(8) Filed in categories: Count values, Dates, Excel, Frequency, Sum, Unique distinct values, Year

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

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, 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

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

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, 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

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