## 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 …

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 …

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 …

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

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 …

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 …

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 …

=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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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. …

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 …

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 …