I've scoured this site for the past hour and can't seem to use any of your
suggestions to get my formula to work.  I'm sure it's just a misplaced
character or something but can someone help?
If my VLOOKUP value is not found in a second workbook, I need to return the

I have entered a formula for adding accross worksheets  ie   =sum('Jan:Dec'!B2)
I use this as I have a workbook that contains eorksheets for each month and
another sheet for the annual totals.  I want to add the values in the monthly
sheets to get the annual totals.

Hi Experts,
I have the following problem which I need to solve and have no idea on which
functions I can use:
In sheet one I would like to get a name of a person which has 2 conditions

I have 2 sheets. In one i make calculations in other i have data
(DataSheet)
Id like to extract exact data from my data sheet. I have unique
identifiers in both sheets for the same items, so I tried to extract

I'm stuck up with a problem here and I hope I'll get some help here. I want
a conditional validation done on one of my cells. This is how it goes. I'm
working on a report that spans multiple teams across multiple locations. The
person running the report will have to select the ...

I need to embed if and sum functions.  I know there is a way of doing this if
you have more than one condition.  For example if you wanted to sum if column
A had a value of 1 and column b had a value of 2, then sum the column c
values.

I have an actual sales report by month and a separate line for budget with
all 12 months. I want to generate a report monthly which will give year to
date actul and YTD budget. Actual is easy as forward months will be zero. How
do I total the proper number of months from the ...

I am trying to use SUMPRODUCT instead of COUNTIF to count the number of even
values between A1 and A20.  The following attempts do not work:
=SUMPRODUCT(--(--ISEVEN(A1:A20)=1))
=SUMPRODUCT(--(ISEVEN(A1:A20)="TRUE"))

please I want to know what is benefit of using advanced Filter?
Any example or web page demonstrate advanced Filter
Thank you

OK here's the problem.  Asignment in school due tomorrow.  I have to use the
MIN function to find the lowest expense in a row of three cells (B38 C38 and
D38).  No problem thee =MIN(B38:D38).  But I have to embed that function
within the LOOKUP function in order to find the ...

I'm doing a GPA chart and want to have the letter grades entered in one cell
and have the corresponding number in the cell beside it... I'm not asking the
right question so I'm not getting the right answer :-).
Kevin

Want data table cell with the maximum and minimum values of another page to
show as a/b in a cell. Is this possible?

Column F is sometimes empty.  Sometimes does contain a value.  Column H
contains the formula = F1 / 900.  F2 / 900.  F3 / 900. ...  Currently, if a
row in column H refers to a blank row in column F, I get a return value of
zero.  Any way to write the formula so that if row F is ...

I want to get the parameters of a sequence in terms of Gaussian
distribution.I mean, mean value, max. and min. values and standard deviation
of that sequence.
Regads

If I have two column as below:
(ColumnA)     (Column B)
1. Apple                    35
2. Orange                  5