amount

Hi folks, I am relatively new to Excel functions, but have set up a shared sheet in Google docs for my friends and I to do an online auction for our Fantasy Football draft in real time. I have each of our names in a separate column across row 11, and a blank cell below each name in row 12 for...

Hi please see the photo in the link; https://ibb.co/RPmLYTz Is it possible so that A16:A24 will display a product code and C16:C24 will show the total amount of each product?

I have a table in Sheet1 (query1) which has vendor numbers and invoice numbers Sheet2 (query2) is the data table and has vendor numbers, invoice numbers, amount, paid dates I want to load both as a query and merge them I would do 'group by' for the Sheet1 table using the first two columns to...

Hi, I have a total amount that is calculated based on multiple inputs. Is there a way to store the latest amount in another worksheet matching the ID for that record? Thank you

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

Good morning Mr. Excel community, I have a questions and wondering if you can help! <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr...

I am creating an expense sheet, and when it comes to meals, some claim what they actually paid and others claim the per diem amount. I'm having a hard time to figure out how to use the max function to give me the actual amount spent or the per diem but not going over $40.00 Here is how its set...

Hello, I have an excel that contains total month wise time for each employee in columns. Total amount for each employee needs to be as calculated based on a slab. The slab is For 0-20 Hours: $8200 + $50 Per Hour For 21-40 Hours: $9200 + $60 Per Hour Now if a person has worked 38:55 Hours in...

Hi all, I want to run a query which identifies the number of transactions conducted per account per hour and the amount. my table have 3 columns A: Account Number B: Transaction date & time C: Transaction Amount I have searched the forum q's but didn't see anything relevant so far. So...

I have a calculation Problem In My Application In which I need to Calculate Reverse Amount From Grand Total Amount. I Need Logic/Formula for It Need you guys Help. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...

https://1drv.ms/x/s!AvjBsEPEq12ngSB0nBRb6FOkOLJz?e=Jfo3wo Hey guys, I am trying to reduce my first table (where I have my data) into the desired output which shows information for unique values in Column C. In Power Query, I have Grouped By the first four columns. In the Group By popup menu...

Hello, Thanks for reading. I have columns of data from column C right through to column WZZ. What I want to do is to put all of this data into column A only. Each column has the exact same amount of rows - data starts at row 6 and finishes at to 2,500. Is there a qucik way to do this...

<tbody> A B C D E AA AB AC 1 Invoices 2 Year Remaining Task Funding Invoice Task Fund Amount 3 2017 3014.03 97 M 0 5 2015 6460.71 98 L6 60.71 98 L6 60.71 7 2018 580.28 99 F 0 100 A 5600.74 10 2019 6956.39 99 F 0 11 2017 5510.74 100 A 5510.74 13 2018 8737.52 100 A...

Count of Amount as per Date Selection!Dears, Need a formula in amount column to count the no as per dates and after 920 cells entry for specific month the amount will change and result will be accordingly. On selection of month in drop down of Cell E1 , Total Count of cells for specific month...

Hi. I hope someone can help me. 1. I need to get the specific amount next to the word Principal For example: A1: bla bla bla xxx xxxx blabla bla bla bla blaPrincipal:1,000 xxx bla bla xxxx xxxx xxxxx bla bla bla 11/14/2017538.95Interest and bla bla bla Basically, all of the data are pasted...

I'm searching for VBA code that would copy X amount of rows starting with 1A from all sheets to a new sheet. Say if I had 13 sheets, it would copy the first 20 rows of every sheet and paste to a new sheet with the 260 rows. I would like to be able to specify and change the 20 to any amount...

Hello, I have two dates and an amount field, I want to break the revenue into each month. I have a formula =(IF(AND($B2>=D$1,$A2<=DATE(YEAR(D$1),MONTH(D$1)+1,0)),MIN($B2,DATE(YEAR(D$1),MONTH(D$1)+1,1))-MAX($A2,D$1),0)/($B2-$A2))*$C2 It breaks down the revenue incorrectly across the months. I...

So I am creating a bet sheet to track all of my bets for a golf tournament. The sheet has the bet amount and then a cell for my score and my openents score. I was trying to figure out a formula that stated that IF my score was higher than the opponents score to return a negative number (loss)...

I need a formula that will sum up all the checks written for the month of December and that the transaction is only a check, so that data has the date of check, amount and the fact that it is a check or a wire. Can someone help?

How can i get the relationship among this 4 variables a = no of days = 30 b = rates/number of holes/ma = 315.81 c = expected monthly target (number of holes) = 240 d = expected production amount = 75,795.36 (Naira) regards