I am working with a spreadsheet that caculates tuition balances for a small
school, about 90 entries. I have it all working just fine with regular
formulas, that is all but one. I would like to see at any given time how
delinquent the families are with their monthly tuition. ...

Good morning to All of you
Situation:
- I have dates like "From" and "To" in A1 and B1
- In C3, I have the formula =+SUMPRODUCT((names=B6)*Hours)/8

=SUMPRODUCT(--('DETAIL 11-04 CTRTS'!$A$4:$A$842=DATE(2004,11,2))*('DETAIL
11-04 CTRTS'!$K$4:$K$842="  ")*('DETAIL 11-04 CTRTS'!$E$4:$E$842))  I need to
sum column E based upon a date condition in A and a blank in K. The above
returns 0.00.  

Is there a "and" function available in Excel?  I want to check the contents
of two different cells and if both are true change the format of another
cell. For example:
if "a2=AST" and if a3="Y"  If both are true set the conditional format. Thanks

How can I format a cell to have quotes around the contents in excel

I have defined a named list (A1:A500 named CompanyNames). The lis
currently only has 3 items but gradually companies will be added t
this list. In a second sheet I have specified the list CompanyName
under validation for all cells in column B. When I click a cell wit

Hello, All!
I'm having trouble getting this formula to work:
{SUMPRODUCT(--(WBS!$A$2:$A$423=$A46)*(--(WBS!$B$2:$B$423=$F46)*WBS!$E$2:$E$423))}
1st section is comparing a text field

How do I round to the nearest whole 5? Example 6.6 needs to be rounded
to 5 or 28 needs to be rounded to 30. The rounding function only lets
me round to tenths, hundreths, ect.
Thanks in advance.

I guess I did not make myself clear in my original post.  I need a formula
that If A1<=B1, A1-B1,0 and If A1>=B1-A1,0.  When I try this as an IF formula
it comes back FALSE.  This is for a cash over/under formula.  For instance
when you take in money at a restaurant, you find ...

i wantto copy data from a front work sheet to different work sheets i am
using the copy function then paste options link cells. this iscopyingthe data
across fine but empty cells are being filled with a 0 or default date, how do
i ensure that these fields stay blank as in the ...

I have a very longer list (column) of numbers for two years, by day.  Each
day contains 12 numeric entries.  I need to determine the daily average of
these numbers.  While an average formula can simply be used, it has to be
re-entered for every 12 rows 730 times (365x2).  Is ...

What formula should I use in Column C to return the % figures in Column C?  
This formula in Column C should rank in percent the numerical rank in Column
B for Each Label indicated in Column A.  
For example, in the first row below, it shows that 4 in Col B is in the top

Here is my Pivot Table dilema:
Fields:
"Employee"  "Total Vacation" "Vac Reported" Caculates = "Remain Vac"
This part works at this level as I add item formula: Total Vacation - Vac

Good morning guys
I have a table with 3 colums
- First name
- date

I need to insert a box in a worksheet, that other users will be able to click
on to make a check or X. Please help