hi, i am wanting to use vlookup and sum funtion together but dont know
how, i am using a table for transactions (employee names and prices).
what i want to do is search the transactions and add up the total sales
per person.

I want to add the values of a column but only for the rows that are marked
with an x in the adjacent column. Like this
A  B
1   x

I am trying to find a function or any other means to add up a row of
numbers. The example is:
Week numbers on row 2
Value on row 3

Hello world, hope you can help on this topic:
I am using the formula that returns the value of an intersection
between a column and a row, as in "=(sales January)" where 'sales' is
the name of the row and 'January' is the name of the column. The name

When I make my estimates and sales quotation there are some rows which are
still empty, and down to these rows is a row with totals of values. I don't
want to print these empty rows from different worksheets.

I am trying to create a report in order to calculate spends per customer
which consists of two work sheets –
The first worksheet has all the sales data as well as the sites and customer
mixed in the same worksheet

Is there a way to run a macro when you select/point at a cell (blank cell,
cell with a formula or cell with a named range)?
Thank you,

I am trying to use the if statement to the following pruposes:
if A1 is greater than 13000 but less than 14000 then £25 is entered
into the cell. however:
if A1 is greater than 14000 but less than 15000 then £35 is entered

If I type a name from an existing list on another worksheet in Col A, I would
like the address, phone number or whatever to automatically pop into the next
consecutive columns without having to physically type the info in.  what
formula would I use.  

How do I format a spreadsheet to fit an entire page without changing font
size?  It can be spread through several sheets but with the amount of
information I have in it now, its getting too small to read.  
Thanks!

So, I thought I had this down - but started up the file today only to
find that the date is a week off... I don't know why - it was fine all
last week.
Here's the formula I have currently:

Please, help. I got many exel files with diferent names but with the same
layout.
How can I combine the files to one sheet? For example.I have 50 files and
every file has 100 row. I need one file with 5000 rows.  

I have a sheet with two seperate columns of names and would like any name in
list 1 that also appears in list 2 to be highlighted in both lists.
Exapmple...
  A          B

I have a worksheet with the following data in Sheet1
I donot want to use advanced filter or Pivot tables
Col A   Col B  Col C
Ram    ABC    Hi-Hi

In a VBA macro I have a loop which processes 180 times and which
either deletes a row or not. This takes a couple of seconds to
complete.
However when I open a second large 35Mb workbook file in memory, the