## Excel Ledger

TOTAL MZN ZAR USD 200 200 200 No Date Currency Narrations Debit Credit Balance MZN Balance USD Balance ZAR 1 1-May-19 MZN Income 100   100     2 …

## Complex Formula

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

## Sum If Array Formula Question

I’m trying to use an array formula with sumif and know the correct format is along the lines of …

## Sumif multiple criteria

I’m sorry if this as been answered somewhere else but I’ve been looking seemingly everywhere for an answer! I’m trying to work out a sumif …

## Sum(Indirect())

Hello, I have a worksheet that has the user ask how many stages they need on “Stage1” worksheet and then stage1 worksheet is copied. I have a …

## Excel countif command

Hey, If i have a cell range for foreg: a1:a100 and b1:b100 and i want to know if a1+b1=7 for each row and get the countif value that total 26 cells return with …

## Excel IF and vlookup combination help

=IF(SUM(\$K2+\$N2+H2)-\$M2<0,VLOOKUP(\$B2,’Container QTY’!\$A\$2:\$B\$219,2,FALSE),”0″)    Hello – i am not sure how to …

## SUmproduct for multiple columns

Hi, I am looking for a formula that combines sumproduct and I think offset. With sumproduct I identify a specific cell and I would like to sum the following N …

## SUMIFS function

Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a completely …

I am creating a spreadsheet that models the sale of some single family homes. I have built a sale schedule that says X of the homes are to be sold per month, …

## Sumrange in a dropdowm during sumifs

Hi, I am using sumifs and my sumrange is a dopdown. How do we do that. I understand that we can put multiple filters by sum criteria and use drop downs in sum …

## How to sum multiple rows and columns

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

## Sum Column Until Condition Is Reached

Hello, I have 3 columns: Column A has categories: Column B has Amounts, and I would like Column C to auto sum every time there is a new category in A.  So …

## Sumif or Vlookup based on several criteria

Hi … using Excel 2010 I’m looking to get a sum of 5 different numbers referenced by “codes”, and wondering if there is an easy way to …

## Sum by cell background colour on Excel 2010

Can anyone please help? I have a standard worksheet with some cells highlighted in yellow. The colour is random and of no particular significance. I’m …

## How to Sum a Range of Cells by Background Colour

Just recently I was asked if it was possible to sum a range of cells by their cell colour, rather than counting the number of cells with a matching colour. …

## Excel SUMIF Formula Not Matching Criteria

In a previous post I talked about SUMIF – summing cells based on a condition, in this post I will talk about SUMIF based on not matching a criteria. So …

## SUMIF Function – Summing Cells using a Condition

In a previous post I talked about how to SUM cells using Excel’s SUM function.  This is a great way to sum cells quickly, but did you also know you can …