Excel 2003,
Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for

Worksheet 1:   Grid!F10 = 4
                     Grid!F3 = 10 (1,000 units / 100 increments)  
Worksheet 2:   Formula in Cell =VLOOKUP(GRID!F10,mid_lcov,(GRID!F3+1)+1,1)
mid_lcov (range name) =        

I saw the "merge" button and tried it and a window opened up and told
me some information may be lost, and lost it was!  What good is that
and how can get around it.
More specifically, I've got say 4 cells to merge into one and I've got

A1 contains a formula which gives a number, eg 127
How do I think incorporate this into a countif, eg
=countif( E6:E value in A1,"apples")
Many thanks.

Column A has in it a list of dates. It's quite a long list but some rows are
necessarily blank.
For the same number of rows, each cell in column B has a number in it.
Is there a formula that will display in one cell, say C1, the total of

I have 2 date fields, B30 & C30  and a number field F30.  I want to calculate
the Net Workdays between B30&C30 putting the answer in F30, but if C30 is
blank, I want F30 to be blank.  I used this code  in F30  
“=IF(C30="","",NETWORKDAYS(C30-B30))”  but I can’t get it to work. ...

I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).
I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Hi - I have two worksheets with employee data in over 7,000 rows. I need to
see which names on worksheet 1 are in worksheet 2. On both worksheets the
full names are in only one column and they are in varying order in each cell.
So for example:

is there an alternative to using IF, as I believe one is limited to 7 IF
statements in a formulae.
My scenario is;
Column A contains 15 different values, let's say

Is there a way to look up a value from one cell to then take the result to
look up an additional cell?  I would like to take the result of say :
VLOOKUP($A21,'BUYER GUIDE'!$A:$AO,2,FALSE) to then be able to look up an
additional value.  

Pls help. I'm not sure if I'm thinking this through clearly. Here goes:
    QTY/$ Amt   
Lemons    20    Qty
Oranges    $1,000     Amt

I don’t know if this is possible.
I would like to change a tables’s data from the following presentation:
id    selection
1    50

I've got a column part table - column A is the Part name and Column B is the
Product Category. I add to the part column monthly and would like to have a
formula in column B that if column A contains a specific word that it would
be equal to a part category in column B. I could ...

I am trying to format a cell through user defined function. Code is
like.
ActiveCell.Font.Color = Red
but it is not working.

I have a worksheet and a need to sum cells with a certain font-color.
I have a number of rows with tasks listed. In the coloums i have 12
months and i the cells are workhours per task per month placed
registrered.