WednesdayThursdayJob1Job2Job3Job4Job5
would like to be able to put the total amount in dollars on each job number for each day if that is possible. I cant think of an easy way of doing this just multiple sheets.
ex: on wednesday job 1 would be $167; job 2, $0; job 3, $104;etc..
NameJob #WednesdayJob #ThursdaySS#Rate/Hr23ABC123$11.001718ABCD1234$15.001646ABCDE123245$13.003838ABCDEF123456$16.004927
I'm trying to put together a spreadsheet that tracks disc capacity increases, affected by any incoming projects. I've managed to do so for one project, but would like to for up to 10. The way i've designed the solution (i'm sure there are far more elegant ways, but hey) is thus:
A forecast worksheet keeps track of a grand total, taking information from sheets P1 -> P10 (being projects 1 to 10). I am unable to figure a way to add up all the increases from all 10 project worksheets with one succinct formula. What I use so far is: ='P1'!C83+SUMIF('P1'!E82,"=2009 - Q1",'P1'!D82) ..................
Here is what I have In cell H4 I put the following code =B5:G5
But when I add number in thous cells nothing happens. I want cell H4 to keep a running total of cells B5 through G5 so as I add numbers to the cells I would like the total in H4 to change.
I have several cells that I use the "DATEDIF" function to added dates and display as, "1 M 2 D". I need to add the multiple results to get an sum of all of them.
Column C1 is the start date.
Column C2 is the finish date.
Column C3 is a separate start date.
Column C4 is a separate finish date.
I used the following formula to get the month/day count for each separate start/finish dates: =DATEDIF(C1,C2,"M")&"M"&DATEDIF(C1,C2,"MD")&"D". Both give me the result I need. I have blown a gasket trying to add all the start/finish into a single Month/Day number. Sample result should look like this:......
I'm having issues with a formula that I am using to add three vlookups together. The problem is that there may or may not be data in one of the columns I am looking up with the vlookup. I am looking up hold times for reps each week then adding them together to get a monthly sum. This formula works when data is available for all 4 weeks. When I have a rep that started in the middle of the month there isn't data for all 4 weeks so I want Excel to just treat that as a 0 or Null, Currently it just provides a 0.0 for the whole thing instead of adding what is there.
=(IFERROR(VLOOKUP([@Name],Sheet2!A:H,2,0),0))+(IFERROR(VLOOKUP([@Name],Sheet2!A:H,4,0),0))+(IFERROR(VLOOKUP([@Name],Sheet2!A:H,6,0),0))+(IFERROR(VLOOKUP([@Name],Sheet2!A:H,8,0),0))
I am performing a sumif to look to see if a number starts with #, then another to see if the the class is text, both are fine and both return values of 1 if it meets the criteria. My problem is i then need to add a sumif (or something im not quite sure wot) to add the cost if the number begins with a # and the class is text (so baically if both the other sumifs = 1).
View 9 Replies View RelatedI have a quotation that I am working on that I need to add 12.5% onto each seperate line price.
There are 300 individual lines on the quote all with different pricing but they all need 12.5% adding on so I am hoping there is a simple way to do a bulk sum for all of the rows rather than having to go through each row and creating a sum for each. - ie =(K28*1.125)
=IF(A5:A6="John","Present", "Off")
How to add few more names aside from John. What if I wish to add names like William or Leo on the search criteria?
For example, John or William or Leo
I'd like to add the numbers in column C that correspond with Fuji, Fuji Royal, or Fuji Premium in Column B. Essentially I am trying to count up the total number of all variety of Fuji apples. I've tried using the sumif and sumifs formula, but haven't been able to crack it.
RED APPLESSIN ESPECIFICAR2.352
RED APPLESROYAL GALA1.029
RED APPLESCRIPPS PINK280
RED APPLESROYAL GALA896
RED APPLESCRIPPS PINK1.064
RED APPLESFUJI867
RED APPLESFUJI PREMIUM1.919
RED APPLESROYAL GALA4.871
RED APPLESCRIPPS PINK1.176
RED APPLESFUJI112
RED APPLESROYAL GALA1.064
RED APPLESSIN ESPECIFICAR2.282
RED APPLESSIN ESPECIFICAR4.522
RED APPLESCRIPPS PINK1.176
RED APPLESROYAL GALA2.352
RED APPLESCRIPPS PINK7.056
RED APPLESFUJI1.96
RED APPLESPINK LADY1.344
I have a spreadsheet with 4 columns.
A, B, C, D
I want to multiply A*B and then add that to C*D
=SUM(A*B)+(C*D)=TOTAL
However, when I dont have a value/number in A or C I get a #VALUE in the total cell. It will only calculate properly when I have numbers in all 4 cells.
Is there a way to set it up so it will calculate if cells A or C are empty? I dont want to have a zero in these cells - just leave empty if no value.
Also - when the total cell is empty I want it blank.
I am compiling a database of tennis stats for various players. I input the set scores (like 6-4) and I then need excel to find "-", go to the left and right, and add up all cells containing these scores on a full row.
For example:
6-4, 6-4, 6-4 would become 18-12
I can do this by using "find" and left/right. The problem is, the more records I add, the more I have to keep changing the formula.
[Code] .........
Is there a faster way to do this, preferably without using macros.
I am using the formula =IF(OR(E2="COLD"),"33%")
Which changes my cell to show the text 33% if the text cold is entered into cell E2. Now what I would like to know, is if I can add multiple catch words to give alternate pre defined percentages. Such as warm and hot to give the respective answers as 66% and 99%
I have made a text box in one sheet where the user will enter the text that is to be added, and it works! How do I get the exact same text box to be entered into all of the sheets in my workbook?
[Code] .....
I´ve made a simple macro in order to make easier to add new rows in a table, by filling the cells with the new data.
The problem is that according to one of the fields, I´d like that macro to add multiple rows, with exactly the same information but numbering all these rows on this specific field from 1to the number I filled on the respective cell.
For example, I have beyond another fields that I´ve already filled, the field "Parcel" and "Total of Parcels". I filled parcel with number 1 and total of parcels with 5. Then I´d like the macro to add 5 rows with the "total of parcels" cells containing 5 on every row and the field parcel filled with number 1, 2, 3, 4 and 5, for each row created.
Let me explain this as best I can:
I have an excel file with multiple tabs on it. Each tab has the exact same format with different numbers. On the last page I want to add cells from each tab and have the sum go to a cell on the last tab.
I'm having difficulty assigning multiple macros to an active x combo box. I want a different macro to run every time the user selects a different location from the combo box. I can assign one macro to the button no problem, but don't know how to incorporate more. The two separate macros I want to run are:
Sub Atlanta()
'
' Atlanta Macro
[Code]....
I have a spreadsheet with multiple similar entries I would like to add up. What would work well for me is to be able to input a column like a and a target column like e.
So in this case it would search throughout column a and wherever it finds a duplicate entry add column e and then delete one of the rows. I could then run it again under different column criteria if needed.
So if I had the below sheet:
I could search by column a and add up column h to read like this:
Im' working on an ROI spreadsheet at work and looking to add multiple IF statements leveraging one cell. an example is this:
If E51 is > 1 and < 100001 then the cell should equal "PREMIUM"
If E51 is > 100000 and < 175001 then the cell should equal "PREMIUM PLUS"
If E51 is > 175000 and < 250001 then the cell should equal "ENTERPRISE"
I have a formula already prepared in the spreadsheet that will come up with a value anywhere between 1 and 250,000 in cell E51. I need that cell value to be PREMIUM, PREMIUM PLUS or ENTERPRISE; depending on the value and can't work out the correct formula.
I would like to be able to use VBA to add a total amount from different worksheets. What I have attached is a copy of my workbook. It is a blank PO and at the bottom is the word total. Is there any way that I could use VBA or an add in to be able to sum the numbers that are adjacent to the word total on separate worksheets?copy.xlsm
View 2 Replies View RelatedI have multiple sheets (Sheets "A", "B", "C", etc) with the same structure and formatting. For these sheets ("A", "B", "C", etc.), I want to create dropdown lists in column F (cells F2:F100) based on values from a different worksheet (Sheet "DropDown", Cells "B2:B130").
I saw a previous post [URL]... which had a single sheet example. I am trying to come up with vba code for multiple sheets and so far it's not working.
VB:
Dim wkst As Worksheet
For Each wkst In ThisWorkbook.Sheets
ThisWorkbook.Names.Add Name:="listdata", RefersTo:= _ "=dropdown!$B$2:$B$130"
With wkst.Range("F2:F100").Validation .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=listdata"
End With
Next
End Sub
I am a beginner with vba coding
I have a list a time (HH:MM:SS) that i want to sum together to get the total number of minutes.
It works if I use simply add A2+A3+A4 etc, but not when I use sum(a2:a4).
There are over 2500 lines of data.
Sheet attached : times.xlsx
Any way in which i can 'paste link' and then 'paste link' again without overwriting the first link. example i have a row (say A1 to H1) with varying values in Book1 Sheet1. i know how to copy and paste a link to that onto, lets say Book2 Sheet1. but now in Book3 Sheet1 i want to copy and paste a link from A1 to H1 over to Book2, but have both links open for auto updates.
View 3 Replies View RelatedI'm trying to set up a billing form for my work. I'm trying to include drop down list for each sections (personnel, equipment, and supplies), then all sum together as a bill. I'm not sure if this is doable in excel.
View 9 Replies View RelatedI am having difficulty trying to consolidate a much larger version of the attached spreadsheet. I need to be able to have excel automatically add up the assets, based upon the firm ID. I have looked around and thought that SUMPRODUCT or SUMIF would work for what I need, but I've been unable to get either to work. I almost need to do a VLOOKUP and have it SUM at the same time.
View 3 Replies View RelatedI believe this would be a very simple query for some but I am a complete novice in VBa and am using a msgbox in one of my file but I need to split the message text into multiple lines but I do not know how to do the same.
View 6 Replies View RelatedIs there an easy way to change
='Week 1'!$D$21
='Week 1'!$D$30
='Week 1'!$D$39
='Week 2'!$D$21
='Week 2'!$D$30
='Week 2'!$D$39
to
=IF(ISERROR('Week 1'!$D$21), "", ('Week 1'!$D$21))
=IF(ISERROR('Week 1'!$D$30), "", ('Week 1'!$D$30))
=IF(ISERROR('Week 1'!$D$39), "", ('Week 1'!$D$39))
=IF(ISERROR('Week 2'!$D$21), "", ('Week 2'!$D$21))
=IF(ISERROR('Week 2'!$D$30), "", ('Week 2'!$D$30))
=IF(ISERROR('Week 2'!$D$39), "", ('Week 2'!$D$39))
Without having to change each one by hand?
There is a pattern to the numbers.
There are 5 weeks, rows 12, 21, 30, 39, 48 in columns D,I,N,S,X
This is my text:
Test Name1
Test Name2
Test Name3
Test Name4
Test Name5
Required result is:
Test Name1|Test Name2|Test Name3|Test Name4|Test Name5
I have a row of sub-headings at row 12 that require Sort Filters. My problem is that I need the filters on selected columns only. It seems that with the standard filter button I get all or nothing.
View 8 Replies View RelatedA
B
C
D
1
$10
$2.95 to $11.00
$4.50 to $19.00
$17.45 to $40.00
Is there a formula that will add column A to the left and right sides of columns B and C to give me an overall answer range in column D?
I have column of cells containing entries such as V1, V3 and V7. I'm trying (and failing) to come up with a formula to separate the numbers from the letters and add them together: V1, V3 and V7 would together give 11.
I can use the MID worksheet function to separate my numbers from my letters on a row-by-row basis, but I can't work out how to do the whole thing in one fell swoop. =SUM(MID(A1:A10,2,2)) doesn't work, for example.