In another pickle and need some help if you please.
Have columns for our HR to track vacation, personal, holiday, etc. Since
each day could be a different code, can someone help me with the if, else
formula. Can’t seem to get what I need. Can get it for one cell but not the

Is there a way to sum totals based on multiple matches?  Say in the following
example, from a separate sheet, i want to sum up the totals for stationary on
the first sheet.
e.g.

I am trying to add an arai of figures together based on customer name and week.
The sheet that I am collecting the data from has a list of invoices and the
week when they are due, being pulled in Via SQL query (in case that makes a
difference)

how do I Compare two tables and find records without matches in excel

How can I protect a worksheet and still make my combo boxes work?

I a parcel value (real estate) that will be typed into a cell (22,500).  I

I have recieved an Excel spreadsheet that i need to transfer data onto
another spreadsheet and when i copy the date the # sign appears. i can see it
in the formula bar line but it will not stay in the column. Is this because
this came over as an Read only.

I'm trying to predict weight loss at hatching in some eggs I have in an
incubator. It's basically set out as day of incubation in one column and
weight of egg in another. What I'd like, is to ask for the projected weight
on a specific day in the future (always the same day). ...

I have a formula +IF(COUNT(SEARCH($L$1:$O$1,S374)),"UPDATED"," ") that addes
the comment UPDATED when the value in L1 - O1 is found. I need to add an or
to this formula to say if the value found in L2 - O2 is found add the comment
PENDING. How can I accomplish this in a single ...

I have the formula below that sums the values in Range name
'Purchases' based on 2 criteria. How could I modify this to COUNT the
number of instances of receipts, based on the existing 2 criteria?
=(SUMPRODUCT((Store=123)*(Inventory_No=$I$6),(Purchases))/10)

I would like to do something like:
IF(B3>=8 and C3>=8;1;0)
if (B3 is equal or bigger than 8 and c3 is equal and bigger than 8) this is
true give me 1 otherwise 0. How do I write that?

I am using the attached formula, but need to modify it to within a range.  
Here is the existing formula:
Formula =IF((M2-L2>0),(ROUND(((M2-L2)*1440),0))," ")
I need to have the first IF statement to me like this, where MaxTAT=180

I inherited a workbook that has 2 sheets.  It takes TOO LONG to open, save
and even locks up the computer sometimes.  There are 2 sheets involved.  The
first sheet is named BudgetCost, and the second is named CostAnalysis.  The
purpose of the work book is to have CostAnalysis ...

Is there a function or functions to query Excel worksheets like you would a
database?  Maybe using SQL?  
Here's the issue I'm having - I need to design a scorecard type of
spreadsheet with a separate sheet for each employee evaluated.  Rather than

I am not sure how to accomplish this task.
I have multiple columns of data.  I am locating a value in a column (F) on
the right using vlookup to find the max value of the data in this column.
Now I wnat to find the corresponding data that is in the cell in column (A)