Sum Of A Column Depending On Data In Another Cell

Jan 7, 2009

I want to add up items in column H, but only if Column J says "yes" in the same row.

I tried a few methods as I always try to do, but I came up short with this one.

View 2 Replies


Specific Formula Executed In Column Of Data Depending On Selected Value In Cell

Apr 4, 2013

I have a sheet with a country in it in A1 (validation list).

Depending on the country in A1 a country specific IF command has to be executed on a column1 with first cel = A3. This IF command also relies on the values in column 2 and 3 on the same row. (B3 and C3 are in the IF cmd)

I taught to do it like this : =IF($A$1="Spain";$A$5;0) with A5 being the country specific IF command which should be executed when spain is selected. however when I do this, this only works for the first cell ( I cannot drag this formule down, since it will always give the value calculated in column 2 and 3 on row1.

I'm not sure if the best way to 'select' the country specific IF cmd is with another IF command..

View 5 Replies View Related

Data Validation Depending On Column

Feb 22, 2007

Let's say I have data validation on column A, which only allows 2 values, "Number" and "Letter". Easy enough. If the value "Number" is selected in A1, when the user moves to B1, I want a validation list of 1,2 and 3, when they move to C1, I want a list of 4, 5 and 6 and when they move to D1, a list of 7, 8 and 9. However, if "Letter" is selected in A1, when the user moves to B1, I want a list of R, S and T, when they move to C1, U, V and W, and when they move to D1, a list of X, Y and Z. I tried using dependant validation, but can only get all three columns (B, C and D) to either be 1, 2 and 3, or R, S and T. The validation lists would be existing named ranges on a separate sheet.

View 2 Replies View Related

Pasting Entries Into Sheets Depending On Data On A Column

Jun 12, 2007

Let's say I've got nine entries of data. Column A is aligned like this:


What I would like to do is write a macro so that the three entries with "One" in Column A get cut and pasted into a newly-created sheet named "One." All of the Two's get cut and pasted into sheet "Two" and the same thing with the Three's.

View 9 Replies View Related

Adding Data In Column A Depending On Data In B

Feb 16, 2009

Adding data in column A depending on data in B. I have following macro:

View 2 Replies View Related

Loop: Macro To Go Through The Table And Preform An Operation In The Corresponding Cell In Column B Depending On The Value In Cell A

Mar 27, 2007

I have 2 columns and 10 rows (A1:B10). In column A are certain text values. How do I write a macro to go through the table and preform an operation in the corresponding cell in column B depending on the value in cell A? for example, if A3 = "Complete", overwrite the formula in B3 with the value (paste value)?

View 2 Replies View Related

Change Cell Depending On Column Header

Jul 11, 2007

I have a spreadsheet with names and start / finish dates columns down the left hand side then a row of week commencing dates along the top.

for each name row I would like to change teh fill colour of a cell to green to represent the week in which they started and to red for the week in which they finished. I therefore need to cross reference the start and finish dates for each name with the relevant week commencing dates at the top. Somehow! I presume there is some kind of vlookup type formula that I need to use in conditional formatting, but I am not sure what.

View 9 Replies View Related

Cell Lookup - Calculation Depending On Criteria Column?

Jun 29, 2013

Column B




[Code] ..

This is my table. What formula should I use so that Column B shows the calculation depending on the Criteria column?

View 9 Replies View Related

Moving Data From Rows To Columns - Depending On Unique Content In A Field In Column

Jun 24, 2014

I have a worksheet which contains 2 columns which is needed to work my problem.

Unique Work ID and Description

The unique work ID are the same for each description, but there are up to 5 different description associated with each unique work id.

I'm looking for an automated process but where to start to convert the 5 rows in the unique row and 5 column for the descriptions

View 8 Replies View Related

Column References: Get A Cell To Return A Value Depending On Whether Or Not A Cloumn Is Populated

Jun 24, 2006

get a cell to return a value depending on whether or not a cloumn is populated
for example. If i Have 3 columns EUR, GBP and CHF and there can (99% of the time) only be one entry in any of the 3 on any given row. How then can i get a 4th column to return the value EUR, GBP or CHF on the same row as an entry. I have a relatively complicate nested IF fromula but i think this is slowing down the worksheet as there are 500 or so rows containing it. Ive attached an example segment

View 6 Replies View Related

Replace Cell Content- Depending On Other Cell Data

Mar 6, 2009

I have a file consisting of two columns, called, "bom ref" and "material"
I need to show the data as indicated in the file, headed required format required.

In effect where I have a 0, that is the material I need to show for every row with a bom ref. of 1,2 or 3, down as far as the next 0 but not including the 0, when I reach the next 0, the material is a new letter, and that letter needs to repeat down as far as the next 0, but not including the 0 and so on.

View 4 Replies View Related

Sheet Population Depending On Cell Data

Jul 21, 2008

I currently written the following formula, but always have issues when adding additional depending on selection.

D8 is the selection ( Validation ) on PERF EXP FORM Tab, Once you enter the selection... you then go to the Accounts per hour Worksheet
=IF('Perf Exp Form'!$D$8="Test1 14-18 station",IF(('10220DBHE'!B9=A6),IF('10220DBHE'!C9 > 11000,11000,'10220DBHE'!C9),"N/A"),"N/A")

Perf Exp Form
Perf Exp Form *ABCDEFGHIJKLMNOPQ4 *1. GENERAL INFORMATION****************5Customer***Date / Name(s)*6ApplicationSheet Size1UP/2UPOrientationSOG/EOGFold TypeFold Plate# CH***78 1/2 x 142 UPPortraitSOGLetter/ZHeavy1***8Machine / model**Enduro 4-6 station9ConfigurationCHANNEL 1CHANNEL 2CHANNEL 310590-4720-4910 Dual DeckNONENONE11Date / Name(s)*** Excel tables to the web >> Excel Jeanie HTML 4 ......

View 9 Replies View Related

Extract Data Depending On Cell Information

Sep 11, 2006

i have 20 different materials which have codes assigned to them

wh = white
ivory = ivory
db = duck egg blue

etc etc

when i create an order some of the codes will be called up
i want to be able to put them codes plus the description into the worksheet Ideally into the header. if not call a1

View 9 Replies View Related

Show A Certain Cell Depending On Data From A Drop Down Menu.

Jan 2, 2009

I have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.

I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.

I can imagine that this is hard to picture so i have attached the file as well.

View 13 Replies View Related

Call Group Of Data Under Defined Name Depending On Value Of Cell?

Feb 13, 2013

I have several blocks of data that I have defined under several names to make data processing much easier when writting formulas. They problem that I have right now is that depending on the value of one cell, I need to call up a given defined name block of data to be used on the calculations. These blocks are labeled as DATA400, DATA500, ... user will input information that will allow me to determined what block needs to be used, user will input data like 400, 500, ..., but to be able to call a block of data I need to reference the complete label DATA400. I have tried to concatenate "DATA" to whatever value is input by the user and use the concatenated value to call the specific blocks of information but it doesnt work.

View 8 Replies View Related

Copy Data From One Cell To Another In Different Worksheet Depending On Date And Name

Feb 10, 2014

I have 2 worksheets, 1 with a table sorted like this (in a row):

component | start date | end date | assigned to

Second worksheet with a table like a calendar with dates and people (dates in the columns and people in the rows), every component is assigned to each person by dates.

............ | 01/01 | 02/01 | 03/01
---------|----- --|-------|-------
person 1 | comp1 | comp1 | comp2
-------- |--------|-------|-------
person 2 | comp1 | comp1 | comp3

I want the assignment from worksheet 1 to worksheet 2 to be automatically. i will set the start and end date next to the component in the first table and assign it to a person/s and it will be automatically get filled in the second worksheet (the calendar) under the person/s and under the same dates as set in the first worksheet.

You can see a template here: [URL] ........

View 9 Replies View Related

Dynamic File Path Depending On Cell Data

May 18, 2007

I think this is possible but cant find anything on it ........

View 9 Replies View Related

Formula For Showing Data Depending On Cell Entry

May 18, 2007

I need a formula that displays the word "Day" or "Days" depending on cell entry i know the formlula =IF((B12)>0,"Day","") to show the word day but i want it to show "day" if a 1 is entered or "days" if any number over 1 is entered.

View 2 Replies View Related

Depending On Value Of One Cell - Pull A Set Of Data From Another Page Varying Length / Width

Aug 12, 2014

I have drop drown menus that allow you to select 1 of 3 choices and based on those a second set which lists the options for the first three (subset). Now depending on the second value I need to pull a set of x y coordinates that can be of varying length. '


Drop down menu 1 1560, 1669, 1554. Drop down menu 2 1560-1,2,3,4 1669-a,b,c,d. This has been done now lets say I select 1560-1. I need the following to be pulled from a list, the data is a block.

1.00 1.543
1.23 -1.25
0.54 -2.75

This can be of any length.

View 6 Replies View Related

Average Column Depending On Values In Another Column

May 17, 2009

I have tried a few other examples in previous threads that use COUNTIF and ISERROR but I just can't get it right.

Basically I want to average the cells in column J (J2:J6,J8:J12,J14:J18, etc).
My aim here is to determine the average value for each day (Averaging 0 values in this instance is OK).

Now, the date in column A (A2:A6,A8:A12,A14:A18, etc) sometimes returns a blank value, depending on the day of the week (see attached example). This is because, in the full version of the workbook, I have Column A date linked to a perpetual calendar and therefore the dates can change cells depending on the year.

For the Date Cells that return a blank value, I do not want the AVERAGE equation to include the 0 value on these days.

For an example I have attached a month of February where there are blank date cells at either end of the column.

View 13 Replies View Related

Numbering Cell Columns Depending On Other Cell Columns Data

Oct 15, 2011

I would like to know if there is a vba code doing this I have eg 100 columns starting from the column B. At the first 3 rows there are some data. Now im using the data from the rows 2 and 3. The row 2 has column numbers (TEXT formatted) from the user. The numbers starts from the 01 and goes on. But it mights be more columns numbered with the 01 or 02 or 03 or.. The row 3 has consecutive numbers and stars. The numbers start from the 1 and stop when the row 2 changes the number. The star appears when the user insert a new column (to the following example are the columns J, K, L &M )

null null ....

I want a vba code that it has to look for the stars and then to change them to consecutive numbers depending on the above row. So, the previous exmample it would be after running the code like this.

null null ....

View 7 Replies View Related

Set Range Depending On Value In Column D

Oct 29, 2007

I have a list of data in colum A and I want to group them together.

In column D I number the group with the same number.

A1 = Tony D1 = 1
A2 = Tom D2 = 1
A3 = Bill D3 = 1

A4 = Helen D4 = 2
A5 = Marg D5 = 2
A6 = Kathy D6 = 2
A7 = Catherine D7 = 2

And so on..... The list up to 100 names

As you can see group 1 = 3 names, group 2 = 4 names, group 3 = 6 or maybe 7 and so on.

I'm trying to set ranges for them Eg:
set rng1 = A1:A3
set rng2 = A4:A7

but it not fixed to set ranges like that. It's variable and changes every week. Next week maybe rng1 = A1:A5, rng2 = A6:A9.

can I have the VB code to determine these variable ranges.

View 9 Replies View Related

Minimum Value In Column F Depending On Value In Column B?

May 25, 2014

I need command that takes in consideration values from column F only if in column B is value 4.8. And than, I need minimum value of those taken in consideration .d.png here is attached picture regarding my problem.

View 8 Replies View Related

Tally Report Of X: Count On Column B (project $) Depending On The Criteria On Column A (project Description)

Aug 28, 2007

I need to write a couple of functions. Firstly I want to do a count on column B (project $) depending on the criteria on column A (project description). For example a total count of all values in col B if project description is "P" or "A". [I can do sumif functions but this is a countif and I cannot get this right].

View 4 Replies View Related

Summe Column Depending Of Other Columns

May 15, 2007

I want to create a macro that make the somme of 2 other columns when the nummer of the first column ist double(more than one ) and put the somme in a new Rows. like this :

23 5
23 12
23 2
45 4
45 1
46 3 in the news the resultat in the same columns itīs like this
23 19
45 5
46 3

View 10 Replies View Related

Select Range Depending On A Column

Mar 4, 2009

If i have row 10-20 in column A filled, what vba code would i need to select a range in column C that selects rows 10-20

If that 10-20 rows in column A chnages to say 10-50 the vba code will select 10-50 in column C

View 10 Replies View Related

How To Sum Amounts In Column Depending On Currency

Dec 19, 2013

I am creating jet report, however am having to use Excel formula to create totals.

I am trying to sum the amounts in column I depending on the currency, although as it's a jet report it needs to update when the report is run.

My formula: =SUMPRODUCT(SUBTOTAL(9,OFFSET(I4,ROW(I4:I6)-ROW(I4),0)),(F4:F6=Options!B4)+0)

View 2 Replies View Related

Add Or Subtract Depending On Text Value In Another Column

May 3, 2007

I have a workbook to record the attendance of students. Sheet attendance9 for September's attendance. Enter 1 for present, 0 for absent, L for late, E for early leave and blank cell for no schoolday. Sheet "remark9" is used to record detail of attendance for September. In sheet "attendance9", I want to display in cell AT2 the number of times a student absent for 7 or 14 consecutive days. How to count from E2:AH2?

View 6 Replies View Related

Multicolum Listbox - Column 3 Changes Depending On ComboBox?

Aug 19, 2012

I have a multicolumn (3 columns) listbox that is filled from a sheet (ProductList). Col1=product code (column A); Col2=description (column B); Col3=prices (columnC). I fill it when the form loads like this:

Dim rng As Range
With Worksheets("ProductList")
Set rng = .Range(.Range("A2"), _


View 9 Replies View Related

How To Get Dates Within A Column On A Table Highlighted Depending On Value

Oct 31, 2013

I'm trying to get dates within a column on a table highlighted depending on their value.

I know how to do this using today's date, but I am having issues in using a separate set date as the parameter.

For example;

I want all values in a table in =K7:K72 that are more than 30 days older than a value set in A3 to be highlighted red.

This should be quite easy, but every time I enter anything the whole column changes colour when this is incorrect.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved