amounts

I have a column (A) with dates formatted this way "Tuesday, September 04, 2018". I also have a column (B) with corresponding amounts in it. I am trying to use Sumproduct to add all the amounts in column B by month using this formula =SUMPRODUCT((MONTH($A$3:$A$3238)=$C3210)*($B$3:$B$3238))...

<article> Hello, <article> recently Chandoo.org posted very good example of Lenient lookup [Advanced Formula Trick]. Formula is working well, but what if I have many the same amounts? How to list all Names with the same amount? In my case Names= Cheques numbers...

i have a financial tracking sheet i developed that works fairly well for me. but have run into a wall on it when someone asked me to make a change. so here's what i have: on a quarterly basis, spending amounts and their categories from each week are entered on separate sheets, and there is a...

I want to rank numbers based on two conditions, column A has to be >=5.0 and column B has to be >= $100,000,000. What formula would I use in column C so once it meets those conditions it should rank the amounts (column B). If the conditions are not met then the rank should ignore the amounts in...

How do I create a formula to split the prize amounts for ties? (It's for a golf league) Player Score Rank Prize Rank Prize In this example the prize payout should be… A 70 1 ? 1 100...

I have 2 sheets in a workbook that look like: Sheet1: <colgroup><col width="64" span="2" style="width: 48pt;"></colgroup><tbody> amount date 45 3/5/2018 65 3/8/2018 6 4/5/2018 342 4/8/2018 45 5/5/2018 654 5/8/2018 2 6/1/2018 </tbody> Sheet2: <colgroup><col style="width...

is there a macro I can run that would hide any rows 2-200 if the amounts in columns F or G are zero?

I've been tasked with creating a spread sheet that will show a running total, but I'm not sure where to start. <tbody> Amount Total 1 2 3 x 6 1 2 6 4 5 x 18 </tbody> It started out simple enough, enter amounts on the left and a cell on the right would show...

Hello, Hope all are well here! I've been gone for a bit, but now I'm back & doing things with Excel that I haven't done before. This particular issue can't seem to be found anywhere, so I'm calling on the pros here.. I have a sheet with the first column for date ranges and each cell (going...

Hi, I am trying to do a credit control forecast in excel. I want to know two things. On every day for the next 3 months how much money is due each day. That bit I am fine with and have a SUMIFS formula in which works. The second part is; I also want to know how much is still due on old...

Hello! I have a workbook that is organized by clients' names - one sheet for each letter of the alphabet. Each sheet is identical, and tracks sales dates and amounts. Named range for sheets = "sheets" Dates in column A Amounts in column B I am looking to sum the total sales for each month...

Lets say in A2 thru A5 I have 4 different codes for one product all with different amounts represented in B2 thru B5. I then have 7 different people I need to allocate those amounts to in columns C1 thru I1 evenly against their order in C2 thru I2. What would be the algorithm that could be used...

<tbody> Contract End Date amounts <tbody> 1/2/14 </tbody> 50 2/5/14 60 4/6/14 70 </tbody> Hello - I'm trying a sumif (I think) where I need to sum the "amounts" column if the contract end date is within a certain number of months from a beginning date. For example, how would I sum...

I have a data set containing dates and amounts for upcoming, cash flow causing accounts payable and accounts receivable transactions. Those are exported from accounting software and I use them for cash flow forecast. Other transactions are added manually to the forecast. Problem with those...

I have two sheets (named sheet1 and sheet2), column B is labelled $ and Column K is labelled Buyer. I would like to take the buyer names from column K of both sheets to sheet3 column A and the $ amounts from column B of both sheets to column B of sheet3, then if the names in column A are an...

What I have is this: =IF(F3=FALSE,C2-C3,"") This subtracts the amount in cell C3 from C2 if FALSE is in cell F3 I want to add to this formula to add the amounts if F3 is TRUE Just not getting it... Thanks for any help.

Might be a stupid question. I have an amount in a cell. I have items with amounts that total up to the amount in the cell that i do not want the viewer to see unless they click on it. Is there a formula that can create the hidden list?

Is there a way of adding together only 35 cells from a column that have the highest amounts in the entire column? My column D has values from 0 to 100,000. There are over 100 values (cells) in all. I want to add together the "top 35" cells.

Hello and Happy New Year! I need to find a much faster way to determine which debits and credits from two separate columns don’t match off to 0.00. I’m requesting a formula or a macro (or any other way that can perform this tedious task quickly). Column A contains the amounts from one source...

After an initial investment is made (M7) and it accrues interest to a certain amount (T9 table) you can re-invest it. Different amounts are held for different times until it is then released. I need the amounts released to show on the certain day they are released. I included a blue table...