amounts

I have a list of work order comments in range H2:H1150. In each cell is a comment like this: "1/8/10 Employee at work-----refer to doctor----$750 cap per listing." I am trying to extract just the dollar amounts from these cells so I can total them in column I but am having a hard time. I...

Hi Everyone, hope you can help I need a formula or macro to add new sales to existing sales invoices. we have clients that p[lace orders and pay over 16 instalmentsand offten add new items to the first order When we get and order an invioce schedule is created with dates and amounts due...

I want to concatenate 2 $ amounts but I lose the $ and the , in between the numbers. For example: A1 = $100,000 B1 = $200,000 C1 = concatenate (a1," & ",B1) The result I get is 100000 & 200000 So I lose the $ and the commas. Any suggestions? thanks

If I enter a dollar amount (will use $1,513.30 for this example) I need an x or other identifier to show me which amounts combined match that dollar amount. What would a formula look like and maybe even a MACO? <colgroup><col width="80" style="width: 60pt; mso-width-source: userset...

Hi, I am trying to find out a way to submit a data in SmartView (11.1.2.5.810 (Build149)) with VBA. Here is a code i am currently using to test and it works only when the the amounts are static/values but when the amounts are generated by formulas the code does not submit anything. Any ideas...

Hello forum friends, can someone please tell me what is wrong with this formula? I keep getting the error that I have entered too few arguments. =index(B55:B116,match(year(now)),A55:A116,0)) Column A has years in it and column B has dollar amounts. Excel 2016 (Windows) 32...

Hello, In column A I have dates in DD/MM/YYYY format. About 100 rows In column B I have amounts. About 100 rows In a partircular cell say D1, I want sum of all amounts if the date is on or before 31/03/2019 In a particular cell say D2, I want sum of all amounts if the date is after on or after...

I am trying to reconcile a bank statement that has a single dollar amount and that dollar amount is made up of potentially 100 individual deposits. My list of single amounts is approx $116k and the amount that cleared is $106k Is there a macro that will test,in a loop fashion, the sum of...

I have to balance loan accounts daily and what would be the best way to do this? I have worksheet #1 which has a credit and debit side. I have a report I place on a second tab / Worksheet and add amounts posted to each loan and look for differences in amounts. Worksheet 2 I need to...

I have a range of cells in column C (C1:C100) that has dates in them. In column B (B1:B100), there are dollar amounts. Some of the cells in column C don't have dates (yet). I'd like to be able to add up the dollar amounts in column B that don't have corresponding dates is column B. Example...

Hi all, I need your help in the below issue need: sum a production table based on months deposits. what I have: 1: sheet for each client with a table of deposits monthly based 2: all amounts in same rows of all sheets, but months are in different columns what I want: to sum months deposits...

Hi all, I need your help in the below issue need: sum a production table based on months deposits. what I have: 1: sheet for each client with a table of deposits monthly based 2: all amounts in same rows of all sheets, but months are in different columns what I want: to sum months deposits...

Hey all I try and get around all my Excel difficulties myself, but this one has me stumped. I have a list of jobs (of which there will be duplicates) and each job either has a credit or a debit attached to it). I need to organise all the jobs into smallest amount per job BUT keep all other...

Hi there, I need to calculate the bonus to be received by an employee who has generated total sales of for example $180.000. After all the calculations he must take $6.800. The bonus scale is 8% for amounts between 120001-130000, plus 10% for amounts between 130001-140000 plus 11% for...

I have a vlookup column that I would like to sum the dollar amounts that vlookup puts in the column. Thanks

Hello, I have tried to come up with a formula for this, but keep stumbling over myself. There are 4 accounts (We will call them "Account1", "Account2", and so on) in which I need to track amounts transferred between them as well have a current total amount of each account visible. I have a...

Good morning; I have a data model that connects to about 10 tables Is there a way to create a summary spreadsheet that shows total amounts and record counts for each of the tables? Thanks

Dear all It's been a long time since I sought help from your goodselves and I have forgotten so much that even this seemingly easy task is alluding me. I have scoured the boards to see if I can canabalise code for my purpose but with little success. So here goes - please go easy on me and...

I need to match amounts of money in one column to the same amount in another column by summing a selection of amounts in the second column for the same day (not all amounts for the same day). It can be the sum of up to four amounts in the second column to equal the first column single figure...

Good day I am working in a system where i extract information from. When I do the extraction i get it in the below format wen is paste it into excel (Offce 365) <colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <tbody> Value...