I am trying to add numbers from cells if it IsNumeric and for some reason in column K the macro doesnt recognize numbers after row 14?
The range column is "E4:E"
Search criteria is the letter "R" in column "E" Then using OffSet, I go thru other columns and process data. Most of the macro works except for column K after row 14?
I have a conditional formula that highlights dates red when it meets a certain criteria. The file named MS Working, the conditional formatting formula (formula below) works as it should with no issues. The other file MS NOT Working, the conditional formatting formula (formula below) has stopped working as it should. What I did? I inserted a new column to the left. Where the MS Working file has only 1 column to the far left, the MS NOT Working file now has 2 columns to the far left.
It seems as if the formula adjusted itself when I inserted the new column; however, its not working.
MS Working
Conditional Formula: =AND(TODAY()>B3,NOT(ISODD(COLUMN())),B3<>"",OR(C3="",C3=0),B3<>0)
MS NOT Working
Conditional Formula: =AND(TODAY()>C3,NOT(ISODD(COLUMN())),C3<>"",OR(D3="",D3=0),C3<>0)
I have a column of times: e.g. 10:03:00 and I would like to add them all up.
=A1+A2 works fine.
=sum(A1:A10) does not.
I have a column of barcodes. I need to get a formula or script to put |Pipes| as the before the 1st and after the last character in the cell.
E.g. barcode 123456789 should be converted to |123456789|
I then want all the individual barcodes to appear in 1 cell next to each other
E.g. in one cell |123456789|987654321|244346473|686541234|479854635|132498569| and so on.
can some one help me how to add the unique cell values using the formula bar?
like if on column C i would like to add all the row values which have the name "George" how can this be possible using the formula bar?
I am having some difficulty adding a default value to a cell.
What I want to do is have a cell that will read "Enter value here" if nothing has been added, but display the users text when changed.
I've been playing with the IF statement feature for a while, but am getting nowhere.
i have an excel file which contains data, I want to be able to search this file and to fill the cell and its next 3 cells to the right with a certain colour. Is this possible as I have wrote some vba to do this but, Im only able to search and not fill the cells with the correct colour.
I have an excel file with some data in it. I have two columns with one of four words in it. For simplicity I'll call them RED, GREEN, BLUE, and Yellow. A few columns over I have columns "Same" "Good" and "Bad". I'm trying to figure out a way to get excel to put a 1 in the appropriate column, if cell A1 is Red I need excel to look at the word in cell B2 and put a 1 in the "same" column if A1 and B1 are the same word. If the word in B2 is Yellow I need excel to put a 1 in the "Good" column. If the word in B1 is GREEN or BLUE I need it to put a 1 in the bad column. The tricky part is each of the four words RED, GREEN, BLUE, and Yellow have a different set of words that will be called "good" or "bad". So if the word in cell A1 if Green for example it will have a different set of good and bad color words.
So it seems I need four different functions depending on what word is in A1. In the column next to these lists of words I have the date which I'll need to use to give me the sums of same, good, and bad for each day. But first things first. I think I need to use a combination of IF functions and MATCH function, but I can't figure out anything that works. Below is what I'm hoping it will look like when I've got the right formulas.
First column
Second column
Date
Same
Good
Bad
[Code]....
i have a problem adding cells every 5th cell for example i have
=SUMPRODUCT((C10:C67)*(MOD(ROW(C10:C67),5)=0))
this adds every 5th row in this range and it does it right as long as there is no text in the cells in between
it works fine when it looks like this
1
1
1
1
1
1
1
but it does not work when it looks like this
1
1
text
1
1
1
when this happens it appears as #VALUE, meaning an error but i don't understand why if i'm just telling it to look at every 5th row and those specific rows have no text in them
i have a spreadsheet with text in between the cells that need to be added so i need a formula that only adds up the cells with numbers on it, to be specific the numbers are either ones or zeroes.....
I've got a problem involving several Dim'd Variables needing to be added up, they're all Dim'd as Variants though as they can be either strings or numbers at any time.
I need a formula (VBA) to add them up (to add their actual numeric values - not just a "1" if they contain a number) and ignore them all together if they contain string values.
I have a userform that I'm using to add data to a worksheet, with the following
Private Sub CommandButton1_Click()
Dim OutSH As Worksheet
Set OutSH = Sheets("Sheet1")
OutSH.Cells(nextrow2, 1).Value = Surname.Value
OutSH.cells(nextrow2,2).value = ID.value
OutSH.cells(nextrow2,3).value = Date.value
......
I need to ensure that duplicate entries are not made for the same person on the same date. The ID is unique to each person.
IF statement that can check for a duplicate and then come up with a dialouge box with some custom text, and then exiting the sub?
I am needing so I did it as a picture. (Please assume "Day 1" is A1)
View 7 Replies View RelatedI have a range of data (techniques) - example below....
AQ - Ask what other topics to include
No DT - hjhjh
ISL - Ask how Saj would manage the time
AQ - Ask if there's anything else Saj wants to cover
I need to be able to calculate how many different techniques are used. No DT shouldn't be included in the count and if a technique is repeated, it should only be counted once. So the answer to the above is 2 as AQ appears twice and there is a No DT.
I am trying to create a spread sheet where I have different columns. The columns consist of name and dollar amount. Names may occur more than once. I would like to scan the column with the names and copy the different names to another column. Once that is done, I am hoping to copy the value or sum of all values associated with that name to the column beside it. I am going to have a long list of names with different values and I would like to sort them and add up those values. I have attached an example of what I am hoping to achieve. I am hoping my 'Sum of Values' is actually summed, I left it longhand for explanation sake.
Name
Value
Name
Sum of values
x
4
x
4+2
[Code] ....
This is a simple one, for someone who is smarter than I. I need to add a column but omit the rows that are blank or has a zero value in either row C or D. In other words I want to add every row in column C if there is a value in row C&D of that item. Attached is a small example.
View 2 Replies View RelatedUsing the attached example, how do I get Excel to display in cell F8 the correct SUM of cells F4 & F5 without having to manually enter the SUM in column F. I need F8 to the be the SUM of the amounts that are displayed.
View 2 Replies View RelatedI have this sample excel ,and I would like to add each value on the 6th row under the date .But I would like to add values under the same date .
View 6 Replies View RelatedI have numbers in cell K1 to K59 with the following formula =SUMIF (A1:A59,"nm",K1:K59). The formula only adds up the numbers from K1:K48.
View 2 Replies View Relatedhow I would get the top 5 highest values from a group of 20 and add them together?
View 9 Replies View RelatedHow do i go about adding cells when some have the #n/a error?
View 9 Replies View RelatedI am slowly working my way thru Excel succesfully but have come up with another one I can't find an answer for..... YET
I simply want to subract the value of two cells, however the values of those cells are produced by formulae. Hence I get the #Value! error.
Once again I know there's gotta be a simple solution, I just can't locate it
I'll admit that the database I'm currently working on is not a vital on - it's my CD collection but I do use it as a testbed for spreadsheets at work so please bear with me!
I'm trying to add running times of CDs together, but of course can't simply use SUM as it will assume the values are base 10
I've got some extra columns in to separate the minutes and seconds, then for totals to divide the seconds by 60, add the result to the total minutes and finally add the remainder of seconds to this but........
is it possible format a cell so it won't allow erroneous time entries (ie, if I tried to put in 45:65 it would reject it?)
I am having a issue with adding to string values. Basically I have created a variable that will take the value of a Column. This Column number will need to be moved to the next column and so on. I dont know if I have explained that very well. I will give a example
Say Column = "C"
I need to add the a variable that has taken the value "C" and change it to "D". The variable will only ever be 1 character long. How would I add to the ascii value of the variable so that the value changes up to the next letter. This will have to work if they enter lower case aswell.
I know this seems a simple task but I cant for the life of me find out how to add the ascii values.
I need to create a formula to calculate rankings for a race series. there are 10 events in the series, only the best 7 individual results count. and there are 4 events which are mandatory and must be included in the rankings.
Sample attached. Sample rankings.xlsx
Let's say I have 3 worksheets, the first of which being the total of the 2 other one, let's say total Apples, Red Apples, Green Apples.
The first column has the name of the customer, and the other columns afterwards have several other values such as sales in 2012, sales in 2013, year-to-date sales, growth etc...
I want people to be able to type in the name of the customer, then the sales for Red Apples, and the same in the worksheet for Green Apples, and then their total is shown in the Total Apples worksheet. The problem is that not all customers will buy both, and so overtime the cells will no longer be aligned to have one formula dragged across both worksheets.
Is there a way to get Excel to search the entries in both worksheets and compile them in the Total worksheet, summing entries that are under the same supplier name?
i have myself a table on the left is all the members names and along the top are 12 dates (1/1/07, 1/2/07 etc).
In another sheet i have a drop down box for the name of the person and a dropdown box to select a date and then a space to enter the amount paid so i need a macro that will find the name and date i selected from one sheet and take the amount paid into the other sheet and insert the amount in the correct place.
If it is unclear what i mean i will post screenshots tomorrow.
I have a spreadsheet with a series of names in a column and respective dollar values in a separate column. I would like a formula to automatically total the value spent against a particular name (without having to enter the name as a value each time).
Example
John Doe 3.89
John Doe 1.27
John Doe 0.98
Amy Smith 1.56
Amy Smith 2.29
Amy Smith 1.11
Alex Brown 0.67
Alex Brown 4.56
Alex Brown 8.87
I would like a formula to automatically populate a column, spreasheet, etc as follows:
John Doe 6.14
Amith Smith 4.96
Alex Brown 14.10
i have data as ( name , Father name ,CNIC, and there salaries , but there is repeating in this data so i want to add their salaries to one name and delete duplication , it should be done in excel. this data is so long .
View 2 Replies View RelatedI have a short script that runs perfectly fine for copying the value from a drop-down list onto the clipboard. However, there are two selections for which I don't want this to happen:
a) When the text selected says "The result has not been chosen"
b) When the text selected says "The result is not available
I see that this would be an if-else statement, with char/string match- but I am not able to code this.
Code:
Sub copyOutcome()
Set outcomeData = New DataObject
outcomeData.SetText Range("a16").Value
outcomeData.PutInClipboard
End Sub
I have names in A1, A2, A3 and A4 and in cells B1:C4 I have atendance for am and pm.What I need is it to count if someone was in on a day. So if B1 or C1 or both contains "in" then the subtotal will be 1 and added for each row, so it shows how many are in whether it be for 1/2 or a full day
View 2 Replies View Related