adding

Hey, I have a weird problem with summing/adding up. Instead of returning a value, a dash is returned (as if all the values are zero). I've even tried adding the cells individually, and the same happens. All the cells are in the same format (namely accounting). When adding then up individually I...

Hi, I need to sort all the rows from 5 to 37 based on the alphabetical order of the values entered in column V. Is it possible to create a VBA script that will do this automatically rather than doing this manually each time after adding new data? I'm not familiar with VBA at all so any help...

I am trying to add a scroll bar to a dashboard in my Excell workbook. This seems relatively easy. My question is if I end up adding more colums of data than originally anticipated is there a way to set the scroll bar to automatically catch that extra data. So say I have a scroll bar linked to 50...

I have a formula that is =IF(BW:BW+75=0,"",BW:BW+75) what this is doing (not doing) is taking the date from COL BW and adding 75 days to it. I want it to remove the 3/15/1900 in the cells that are blank. I know it looks strange because excel is adding 3/15/1900 instead of 1/1/1900.

Having trouble googling this querry as the Variable name Single is very common. Basically I have code that looks to see if the value in the cell is non zero, and if it is non zero then I add my variable (obtained elsewhere) to the existing .vale from the cell. But somehow the adding isn't...

People I've got this scenario and I've been scratching my head over this for a while today. It's a small survey of 11 participants (b1) who were asked to answer a question. 4 got the answer right (B2), 5 got it wrong (B3) 1 spoiled the paper (B4) but, and this is what's catching me out, 1...

My code consist of a large formula. And I would like to keep on adding to the formula in the VBA. But it looks like I have reached my maximum in that formula that it spills into the second line on my VBA. When that happens my formula breaks. I was wondering if someone had a solution to this...

formula to calculate the date and time within the business hours by Adding hours and excluding Holidays weekends Any Help

Hello, I have built a VBA form in Excel. I want it to have some similar functions as the built in form. Does anyone know the coding to the built in Form? On the left side of the form it has the 1 through 600 (number of entries) and then the next and previous buttons. I have the Clear, Add...

Hopefully this should be an easy question for someone although I've been struggling with it on and off for months! We have various cells in our worksheet that will always have the following format (example) - WC-18-001A, WC-18-001B, etc. I would like for the user to just be able to put in the...

Hello all, Is it possible to write an IF formula that would add currency to a cell? (currency that can be summed, not just the appearance). I've tried but all I can get it to do is put the data, not the $$. Current formula is: =IF(C2="Bonus","$40.00","") I have also tried: =IF(C2="Bonus"...

This code works great. It creates a new sheet every month. I just want it to stop adding once we get to 2019. Any Ideas? Sub AddMonthWkst() Dim ws As Worksheet Dim strName As String Dim bcheck As Boolean On Error Resume Next strName = Format(Date, "mmm_yyyy") bcheck =...

Good Day, This formula works for adding a ticket for every full 1000 =IF(A1<=1000,INT(A1/100),10+INT((A1-1000)/1000)) Is it possible to change above formula base on below rules? Many Thanks Every 100= 1point Between 100 to 1.000= 10point Every 1,000= 1point Between 1.000 to 10.000= 10point...

I can't believe you can't just add percentages with the usual =SUM(A1:A10) formula!!! The percentages I want to add are all created by formulas, not typed into the cell itself. The total percentage at the bottom of the page is adding up the individual weightings from a number of entries. How...

All my variables are Doubles. I have formula like: a X b = Calculated_Value Then I keep a running total of the Calculated_Values: TotalValuesCombined = TotalValuesCombined + Calculated_Value TotalValuesCombined = 140395826 (what VBA has calculated) If I dump all values to spread sheet and...

I've been using this line of code for weeks with no problems. Now all of a sudden, it wants to fail. I've verified that the file path is correct, and that the file exists. I've tried adding DoEvents before and after this line, but it continues to fail. All I get is the Method Open of Objects...

Hi All, I'm trying to count all cells that contain any text + EXCLUDE certain words I'm trying to exclude "BRK" and "SCK" and "HOL" from the range. =SUMPRODUCT(--(T4:AS4<>""),--(T4:AS4<>"BRK"))/2 How do i also exclude "SCK" adding it to above formula? http://prntscr.com/iiym5u < that's what...

Greetings, I am running into some issues while adding a new collection. The collection portion of my script is below: Dim col As New CollectionDim col2 As New Collection col.Add b col.Add c col.Add D col.Add E col.Add F col.Add G col.Add h col.Add i col.Add j col.Add k col.Add l col.Add m...

We work with a lot of workbooks with multiple tabs that contain dated information, tab name, etc. in the header/footer and I want to create a way to automate the updating of the header/footers of these workbooks every year. I'm having a problem adding a picture to the footer, the rest of the...

Hello, My question may be relatively simple. Im curious about adding a function into the formula which I currently have that works. The formula is an IFISERROR. =IF(ISERROR(MATCH(O14,A$1:E$5,0))=FALSE,"Yes","No") The way it works is - O14 checks for a value in my Array of A1:E5. If it finds...