Totals Not Coming Out Correct
Dec 17, 2008
I have been working on a Spreadsheet for GVWR (Gross Vehicle Weight Ratings). I'm having a problem with the Formulas in Excel, I thought you may know what's going on and why it's not giving me the right data. I'm pretty good with Excel, I've been using it for about 17 years for calculating Tank formulas, etc, but have never run in to this before.
I have three columns to the right of the sheet. One is Stock Vehicle weight of an item____(E) The next column is the Aftermarket weight of the item______ (F) Then the third column (G) is the total weight minus the stock weight using a very simple formula =SUM(E6-F6) gives the correct weight in the third column, but at the end of each area (Topic) i have a Total Weight area in the third column (G), using the formula of =SUM(G6:G26) which should just add up everything in column G, but it doesn’t. I have re-made the spreadsheet three times,
View 14 Replies
ADVERTISEMENT
Feb 15, 2010
I'm trying to create a formula that will added the correct amount in the correct cells, I have create a dunny sheet in trying to achieve this. If Cell B8:B11 = ABS or Dum that any points won should be added to Cell L8:L11 right now its adding it into K8:K11. If Cell B8:B11 = is Blank any player points should be added to cells K8:K11. I'm using this formula throughout cells K8:K28 =IF(J8>J25,1,IF(AND(J8<>0,J8=J25),0.5,0)) Any thing in red is incorrect anything in blue is what I'm trying to achieve.
View 4 Replies
View Related
Jan 26, 2014
We receive about 20 sales files of several hundred lines of data each day from various agencies. I want to create a macro / VBA code which checks that the data submitted is correct so that we can upload it into our database without import errors and / or having to manually check each line of data.
I envisage something like an output report:
#####################
149 entries
Column A - Date - OK
Column B - Customer_Phone - Errors (Should be 11 digits)
Row 21 - Customer_Phone - Error (Not 11 digits)
Row 108 - Customer_Phone - Error (Contains letters)
Column C - Outcome - OK
Please correct and re-check.
#####################
View 4 Replies
View Related
Jul 3, 2008
I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.
I need to see how many items processed for each set per day.
Example:
[url]
The problem is that it counts the correct amount but not with the correct
dates.
The formula that I use is:
=SUMPRODUCT(--($I$3:$I$8<>"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=39601)+AND($G$3:$G$8=39601)))
View 14 Replies
View Related
Apr 10, 2009
When I enter 1/2 I want it to stay as a half but when I press enter it automatically changes to the date. How can I stop this?
View 2 Replies
View Related
May 14, 2014
I have a column with codes coming after a # symbol and want to extract just the code from the cell. The code could be 2 or 4 characters in length. Some examples:
#AA abcdef
From this I would want the formula to return #AA.
#ABCD qwerty
From this, I would want the formula to return #ABCD.
The #Code should but may not always be the first word in the cell, so it needs to find the # symbol and then take the next x characters until a space is found. Note that the reason code may be the only text in the field, so a space may not be there at all. For instance,
#RR
Should just return the #RR.
Edit: This actually has become more complex now. The cell could be
#AA{text}
And for that, I would just want the #AA.
The formula would need to begin at the # and return just the next x capital letters.
View 9 Replies
View Related
Jun 16, 2014
I'm trying to format a worksheet to show a one year due date with an alert 30 days out so that I can complete the task before the date due. I am using this for a preventative maintenance sheet for respiratory protection equipment that needs to be serviced annually. For instance; if I service a mask today the next service will be in one year. I'd like it to alert me 30 days out. If I could get that alert through outlook that would be fantastic.
View 5 Replies
View Related
Jun 22, 2014
Here is the first required formula, which will go in cell P7:
If N7>=75 a value of "Y" should be returned. If not, a value of "N" should be returned. BUT if N7 is blank, a blank should be returned.
Here is the second required formula, which is more complicated, and will go in cell Q7:
(1) If Cell P7="Y", then a "Y" needs to be returned in the cell.
(2) If Cell O7>=2, then a "Y" needs to be returned in the cell. If not, then a "N" needs to be returned.
(3) If Cell P7 is blank, then the cell needs to remain blank.
Here is the final formula, which will go at the bottom of the page.
I need the Q column to return an average of the number of "Y" values, not counting the blanks as numbers. (For instance, if there were 18 "Y"s, 2 "N"s, and one blank, the value returned would be 0.90.).
View 6 Replies
View Related
Aug 4, 2014
I've been assigned a project where I'm suppose to report inventory allocation to projects at end of day every Thursday. The past 2 Thursdays, I've just literally been manually plugging in the numbers into the allocated stock column.
The spreadsheet I came up with is attached. The 1st tab is the demand showing the needed quantities per item and respective due/on-site dates. The on-hand inventory (stock) is on the 2nd tab. My current process is:
1. once items have been shipped, I delete those entries/rows from the first tab. This way, only all the outstanding/open orders remain.
2. after completing #1, I then copy and paste on-hand inventory from our database (Navision) onto the 2nd tab.
3. I manually plug in the the qty for each item depending on stock available. This is the part that I would like to streamline.
Inventory Allocation.xlsx
View 2 Replies
View Related
Feb 7, 2014
I want to late coming and early going of employees. eg. office incoming time is 9 am and 5 mints late coming is allowed 9.05am . and outgoing time is 6pm i am not able to calculate late coming if outgoing is 5.30pm and if put formula =IF(E3>=6,0,6-E3) not working properly.
View 1 Replies
View Related
Jan 19, 2007
This macro works when there are only a small number of worksheets in a workbook. But as soon as it increases to say 20 or above worksheets, the macro keeps looping without coming to the end of the last worksheet.
Sub LDK_Print_Orientation_New()
Dim intOr As Integer
Dim wkscount As Integer
wkscount = ActiveWorkbook.Worksheets.Count
For x = 1 To wkscount
Worksheets(x).Select
Application. ScreenUpdating = False 'Switches off screen updating and calculations
x = MsgBox("Print in Portrait", vbYesNo, "Printing Choice")............
View 9 Replies
View Related
Oct 16, 2009
The attached workbook contains a cell with validation list selection and a look up function. The validation list selection works fine, but the look up function is coming up with the wrong results on several items. Is this a bug or am I doing something wrong?
View 2 Replies
View Related
Jun 12, 2014
I have a spreadsheet with note in it. How can I do a search to see what words or phrases keep coming up in the note. with out doing a sort.
View 4 Replies
View Related
Sep 5, 2009
I am to the end of my wits - or maybe it's impossible to do the following with formulas?
I have the data like this:
Column A: Date (which is basically the date for the beginning of weeks)
Column B: Month of the date in Column A
Column C: Year of the data in Column A
Column D: Weekly data.
A: DateB: MonthC: YearD: Weekly data
12/11/200612200619
12/18/200612200644
12/25/200612200650
1/1/20071200741
1/8/20071200737
1/15/20071200741
1/22/20071200741
1/29/20071200741
2/5/20072200732
2/12/20072200736
2/19/20072200740
2/26/20072200735
Maybe it's because it's Friday night, but I just can't invent how to do the following:
Create a new column E that would contain the monthly sum of ColumnD across all weeks of this month - but entered only against the first week of that month (that is currently in Column A)
I.e., in my example it should be:
113
empty
empty
201
empty
empty
empty
empty..................
View 9 Replies
View Related
Jan 16, 2014
I have a line that is commented out in the bottom - that is an example of what types of filters I want to do but dynamically. Users choose multiselection from a list box then it filters the sheet for them. It is pulling the data from the listboxes but when it is more than one item it is Putting the whole thing in as if I said text = "ABERTI", "AMALON", "BCASTE", "BGELLE", "CFRANC" - No I want to filter by each of these (it believes this is one long string)
Here is the code:
[Code]....
This code does not filter correctly.
View 2 Replies
View Related
Dec 24, 2009
I have one excel sheet where I write a macro to create pivot table.
It was successfully ran and created the pivot table but there is no data in that table. Only headers are coming.
View 7 Replies
View Related
Feb 10, 2011
I created a activex ComboBox (under form controls) to show numeric figures.However, the combo box linked cell is showing the numbers as text.
How can I correct this issue?
I run Excel 2007 version.
View 14 Replies
View Related
Jul 29, 2014
I'm using Excel 2008 for Mac & cannot figure out how to add a data label to an XY scatter plot that comes from a 3rd, separate column.
I have 3 columns of data: (A,B,C)
Labels, X values, Y values
When I select the Data Source for the Chart, there is a greyed out box for Category X axis labels, which is where I remember such information going in PC versions of Excel I used to use.
From the formatting palette, the only options to select for labels add the values of column B, but I need the reference from column A.
I'm not familiar with macros or visual basic. How to add these labels? This is Mac, Excel 2008.
View 3 Replies
View Related
May 27, 2012
There are dates in column C and I need to count how many days are coming due within 90 days of each date based on the today() function but do not exceed the 90 days.
Countif Today()+90
View 5 Replies
View Related
Oct 9, 2008
Here's what I have...
Column A Column G
date $ Amount
my data example...
10/5/2008 $10.00
10/5/2008 $20.00
10/8/2008 $12.00
10/8/2008 $8.00
10/8/2008 $25.00
10/9/2008 $75.00
What I want the formula to do is look in Column A find all of the dates that are on the same day and then look in column G and add all of those $ amounts.
So the result would be...
10/5/2008 $30.00
10/8/2008 $45.00
10/9/2008 $75.00
View 4 Replies
View Related
Jun 5, 2014
Here is what I have:
cell b6 =SUM(B3:B4)
cell b8 =C8*B6
cell b20 =SUM(B11:B18)
cell b29 =SUM(B22:B27)
I want to add all these cells together for the total. I used the formula =SUM(B6+B8+B20) and it works fine. However, when I try =SUM(B6+B8+B20+B29) I end up with 0.00 in cell B31
View 2 Replies
View Related
Nov 22, 2012
I'm tracking 50 food items (in column A) for 40 homes (columns B-AO) where each home gets none or varying quantities for each food item (ex: apples 7 for home B, 0 for homes C-L, 19 for home M, etc.). I can get grand totals for each item for all homes, but need to also list how many for each home receiving apples. Ex: 4 homes get apples (4, 7, 19, 1 respectively). SO I want my total sheet to have a column for each food item with the grand total "31" and the second column to show 4 + 7 + 19 + 1. The quantities change frequently so I need a formula I can use for each food item. Also I don't want "zeroes" included. What formula would I use to do this?
View 3 Replies
View Related
Jan 2, 2014
I've been trying different combinations of "If" statements to get a sum for the total items in house or total items at outside vend.
I need something that will be able to differentiate from parts in house to parts outside vend and put the total sums into M2 and M4
Please see the attached sample : Sample Qty.xlsx‎
View 2 Replies
View Related
Oct 9, 2008
Does Excel know week numbers? e.g. Week 40 is Sunday 10/5/2008 to Saturday 10/11/2008. Here's what I have...
Column A Column G
date $ Amount
my data example...
10/5/2008 $10.00
10/5/2008 $20.00
10/8/2008 $12.00
10/11/2008 $8.00
10/12/2008 $25.00
10/13/2008 $75.00
What I want the formula to do is look in Column A find all of the dates that are in week # whatever and then look in column G and add all of those $ amounts. So the result would be...
Week 40 $50.00
Week 41 $100.00
View 3 Replies
View Related
Jul 9, 2009
I need help to total a column but in four cells the values are as a result of conditional formatting and the total ignores those cells. Is this difficult or am I a bit slow? This is in 2003.
View 6 Replies
View Related
Oct 20, 2009
This problem has come at the end of a big exercise whereby I've managed to construct a spreadsheet that automates three payment processes based on various VLookups to another file. However, I've come to a stage where I need to pre-empt a payment allocation based on cumulative totals.
I'll try and explain clearly below but I've also attached a spreadsheet showing the intended result (along with a copy without the output so that someone can add in the formula - again, if it exists.
So, this all centres around a code allocated to our clients and a declaration that they complete. Say client code "Apple1" (col E) sends in instructions to pay on a position of "650,000" (col F). Within our existing spreadsheet we have an available position of "800,000" which can be seen by totalling column G for client code "Apple 1".
So that's the first requirement - for all rows on my existing spreadsheet for client code "Apple1", I want to add the cumulative total of column G ("800,000") I'd like this captured in column H, as per my example.
We can then make payment based on their declaration, up to their total available amount. However, we need to pay them in stages according to our existing allocations (col G). Therefore, taking the first example, their declaration show's an available position of 650,000, their total position is 800,000 and the available nominal amount for that row (col G) is 200,000 - so they can be paid on that full amount therefore, 200,000 should be shown in cell I3.
So now, they've got 450,000 left to be paid and cell G4 again shows a position of 200,000, so once again, cell I4 should show 200,000.
The client "Apple1" now has a payment amount remaining of 250,000 remaining but in this instance, cell G5 is for 300,000 - so because the remainder of their available payment is less than the amount in cell G5, we should post the available payment amount in that field - 250000.
Therefore, if you add up all of column I for client "Apple1" it comes to 650,000 - the amount we have on our declaration - even though the total of their available position is 800,000.
I've included another client in the mix "Sauce2" who should show 200,000 and 0 respectively in cells I6 and I7.
View 14 Replies
View Related
Apr 20, 2009
Let me first explain what my worksheet looks like.
View 2 Replies
View Related
Jan 11, 2008
I have a column of wickets (M). M5 and M6 are the number of wickets for one match, M7 and M8 for the next, and so on. Two wicket entries for each match.
I needed a formula to count the amount of times the combined wicket total for a match is greater than 10. Initially there were only a few M values, so I used this:
IF(M5+M6>=10,1,0)+IF(M7+M8>=10,1,0)+... and so on. Now I want to expand it to have more M values and this formula would become huge.
View 11 Replies
View Related
Nov 29, 2011
I have a file tens of thousands of lines long. This has a bunch of store numbers along with the amount owing to them.
Now this is presented like this
Str 50 $10
Str 50 $20
Str 50 $15
Str 60 ... etc etc
I just need the totals for each store, which I will then copy into my billing file. The person who sent me this original has already subtotaled it, and each site has a plus sign next to it. When I click the plus sign I can see the breakdown (ie store 50 ten times, store 60 twelve times etc) but otherwise the store totals are given on 'adjacent' rows. The problem is these rows arent actually adjacent, the other rows are just hidden. So when I try to copy the store totals all the other junk gets copied as well.
How do I copy just the store number and totals?
View 6 Replies
View Related
Oct 31, 2006
I would like to get the total in column B but its not giving me the correct total. So I would half to use a helper column in column D to retrieve correct results. Is there anyway I could have an all in one formula for this. I would prefer not to use the helper column. The correct result is in cell D23.
View 9 Replies
View Related
