I am tryng  to create a conditional formula with two variables, each of one
can have two values (exemple: if 0,5 day and 1 crew, then; if half day and
two crew, then; if one day and one crew, then; if one day and two crew, then)
, and I cannot find how to do it. can you please ...

I am using the count function for attendance tracking of Vacation, Personal
Time, & Sick Time. (Example: =COUNTIF($F6:$CQ6, "V")
Problem is that, now I need to be able to do half days. I have tried many
different formulas/ways to incorporate the half day scenario even without

I am trying to create a proposal form that based on the number of users
the form changes prices.  
I have a cell for number of users and then have a list of prices based
upon the number of users.  So if they say 4 users it takes the base

I am trying to insert (or delete) rows in a worksheet that I have
protected in order to prevent certain cells being altered. Once I have
locked the specific cells, and protected the sheet, the options to
"Insert" or "Delete" rows is greyed out.

This may be a stupid question...;) however i would really appreciate if
somebody could answer for me what the $ means in a formula...it has
been causing me some problems, and a definition would really help me
out. Thanks--nicole

How do you remove a drop down box within a cell? I tried
Data/Validation/Clear All, but it did not remove the box.
Any suggestions?
Thanks!

Q1: I want to count how many of many data is under "panel" and in in "yellow"
colour. when I use =COUNTIF(A1:B6,"panel") it works and
=COUNTIF(B2:B7,"yellow")) it also works but how to combine this two?
Q2: some answer I saw posted

About a year ago I created a giant spreadsheet that took a large download
from a Financial database, and then sorted it into various categories across
time, using a series of SUMIF functions that specified whole columns (almost)
Row 2 to 65536.

I need a formula that sums the values with 2 different criteria and 2
different look up ranges

I need some help understanding some formulas that already exist on a workbook
that someone else made.  Here is an example of one:
=IF(AND('Past Due Report' !E4>0, 'Past Due Report' !E4<16), 'Past Due
Report' !G4,0)

I have a spreadsheet that looks as follows:
            A                                     B                   C
1    Number Of Days                     5                   4
2                                     11/1/2005              11/8/2005

Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

Is it possible to perform a lottery/raffle drawing using Excel?
If so, how?

I want to remove from one column with 700 cells some characters.For example,
in the cell i have: AABB1234567 and i want to eliminate BB; i try with ctrl+h
but i don't have a result.
thank's

I set up a drop down list in excel and wanted to know if there was a way to
set up a predictive text feature so that i don't have to scroll through the
entire list to select the correct entry.  i would like to be able to type in
the first two letters and have the entry appear.