a formula to search for names in columns and then add the figures

Similar Threads:

1.a formula to search for names in columns and then add the figu

Glad we could help you.

JLatham's solution is easier and more elegant.
You do need to learn about PIVOT tables... it will save you lot of grief. 
Try to master VLOOKUP also.



"Vercingetorix.I" wrote:

> Thank you, I am going over this site and it is great, I didnt expect to get 
> an answer so quickly either... 
> 
> "Vercingetorix.I" wrote:
> 
> > I need a formula to search for names in columns and then add the figures that 
> > are in a different column, so for example i have names in one column and then 
> > need to find each name and add the dollar amounts that are listed in another 
> > column...

2.create relative named formulas using Names.Add Name:= RefersTo:=

Hello,

I'm using a For Next loop to create some named formulas.

*****************************************************************
For LoopCounter = 11 To 18
   ThisWorkbook.Names.Add Name:=Service.Cells(LoopCounter, 1).Value, _
                    RefersTo:=Service.Cells(LoopCounter, 2).Value
Next LoopCounter
*****************************************************************

the RefersTo arguments looks like this:
"ABS(C$173-SUM(C$158,C$165,C$168))<1" (columns relative)

When I run my procedure having cell pointer on column"C" I get
named formulas, which looks like this:
"ABS(E$173-SUM(E$158,E$165,E$168))<1" (offset of two rows).

When I use column"A" in the RefersTo argument I get column "C" in my
named formulas.

CRAZY!

Any help is appreciated.
Excel XP SP3
WIN XP SP1

Best Regards
Werner

3.Loop through column headers to search from column name and get cell range

Hello,

I've been searching all day to try to find an answer to my question.
Unfortuneately I haven't been able to find anything specific to my
issu.  This may be because I am not using the right keywords, so
forgive me if this is a duplicate question of another posting.

Anyway, I have an excel spreadsheet of data that is sent to my group
each month.  I am trying to automate the process of extracting the
data/columns that we need to import into access.  2 of the columns
contain fullnames.  I need to split these columns into LastName and
FirstName which I have already done.  However, in my code it the column
is chosen by the column range i.e (Q:Q).  However, this is not always
true every month, so I wanted to be able to pick the column by the
column header instead.  I am using the code below, but for some reason
it isn't moving across the column.  It is moving down the rows.  Can
someone please take a look at it and tell me what I am missing?

Thanks

    SearchValue = "GOwner" ' Set search value"

    Set rng =
Worksheets("Sheet2").Range("A1").SpecialCells(xlCellTypeLastCell)
    'lLastRow = rng.Row
    lLastCol = rng.End(xlToRight).Column

    Dim cVal As String
    For i = 1 To lLastCol
        MsgBox "Column = " & i
        If Cells(i, "A").Value = SearchValue Then
            MsgBox "Search value found at Column: " & i
        End If
    Next i

4.add figures to existing figures in excel

5.how do i get a column to only add up the figures in a certain

i have a list of figures thats already generated from another report . i look 
at it and code the red ones i want to pay , the blue ones i will pay next 
week and so on . the report has about 6 months across the top so it needs to 
be kept neat by not really adding colums in beside each months column

"City Girl via OfficeKB.com" wrote:

> Will there be a formula / criteria to determine which ones will be in blue
> and which ones in red or are you just going to randomly choose figures for
> colour?
> 
> karen wrote:
> >i have a column of fifures . some i want in red some in blue . i then want a 
> >totall at the bottom of the red figures and blue figures . Is it easy to do?
> 

6. how do i get a column to only add up the figures in a certain col

7. Problem adding column of figures

8. column is added up by original figure not after rounding up